> > I've got one in the works for http://databasejournal.com/, and I
> > hoping someone could look it over for me to catch any egregious
I'm on vacation, so I don't have the ability to test the actual SQL.
article text is fine. You might want to, in future articles, suggest
people run EXPLAIN ANALYZE and not just EXPLAIN in order to see when
query planner is estimating wrong.
BTW, the queries that GForge uses to generate the category counts for
trove map are egregiously bad and generate wrong counts to boot.
basically a loop of queries, one *per category*, when the whole thing
be done in a single query. I've been meaning to fix this for some
but I got hung up on getting GForge installed on my dev machine. Maybe
Aglio Database Solutions
In response to
pgsql-advocacy by date
|Next:||From: Anton de Wet||Date: 2004-11-24 08:41:15|
|Subject: Anyone willing to chat to someone as a postgresql reference?|
|Previous:||From: Tom Copeland||Date: 2004-11-23 18:51:22|
|Subject: Re: Anyone got time to review an article?|