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...

---

blog comments powered by Disqus

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...

---

blog comments powered by Disqus

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...

---

blog comments powered by Disqus

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...

---

blog comments powered by Disqus