PostgreSQL 8.3, it's faster, really it is!
Posted Thursday Aug 23rd, 2007 09:51pm
by Joshua Drake | Permalink

I downloaded the latest check out of PostgreSQL 8.3 (not even beta yet) just to see how things are progressing. Of particular interest to me was a recent conversation about sequential scans I had with Jeff Davis. In short, in 8.3 sequential scans should be faster.
Read more...

---

How many rows do I have anyway?
Posted Thursday Aug 23rd, 2007 12:19pm
by Joshua Drake | Permalink

Have you ever wondered how many tuples you have in a relation? Normally to find out how many tuples you have you would do something like:

SELECT count(1) FROM rows;
 count 
-------
 10002

Read more...

---

Surrogate versus Natural Primary Keys
Posted Thursday Aug 9th, 2007 10:54am
by Joshua Drake | Permalink

This is a constant source of argument, flame and general discomfort with any database design. On the PostgreSQL lists it comes up occasionally and it is always a long drawn out thread with people arguing on each side about which one is correct.

Read more...

---

LewisC and the PostgreSQL vs EnterpriseDB: Hypocritical crap?
Posted Wednesday Aug 8th, 2007 11:54am
by Joshua Drake | Permalink

Yet another round of EDB PR came out today and of course, some in the community disagreed with it. This time I was not a big objector although I do think their PR was a little misleading, I think it was generally a reasonable release and that the community needs to relax a bit. You can see that thread here.

Read more...

---