Skip site navigation (1) Skip section navigation (2)

Re: Anyone got time to review an article?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Tom Copeland <tom(at)infoether(dot)com>,pgsql-advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Anyone got time to review an article?
Date: 2004-11-24 04:39:46
Message-ID: web-6703557@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
Tom,

> > I've got one in the works for http://databasejournal.com/, and I
was
> > hoping someone could look it over for me to catch any egregious
errors.

I'm on vacation, so I don't have the ability to test the actual SQL.
  The 
article text is fine.    You might want to, in future articles, suggest
that 
people run EXPLAIN ANALYZE and not just EXPLAIN in order to see when
the 
query planner is estimating wrong.

BTW, the queries that GForge uses to generate the category counts for
the 
trove map are egregiously bad and generate wrong counts to boot.
 They're 
basically a loop of queries, one *per category*, when the whole thing
could 
be done in a single query.    I've been meaning to fix this for some
time, 
but I got hung up on getting GForge installed on my dev machine.  Maybe

later ...

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-advocacy by date

Next:From: Anton de WetDate: 2004-11-24 08:41:15
Subject: Anyone willing to chat to someone as a postgresql reference?
Previous:From: Tom CopelandDate: 2004-11-23 18:51:22
Subject: Re: Anyone got time to review an article?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group