Re: Any tips for this particular performance problem? - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Any tips for this particular performance problem?
Date
Msg-id 3B4C426E.6EEF45F1@tm.ee
Whole thread Raw
In response to Re: Any tips for this particular performance problem?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
"Ross J. Reedstrom" wrote:
> 
> Hmm, I've pulled the appropriate file from CVS, now. Seems that v102
> has most the indices, so Stephan's request of example queries is the only
> way we're going to be able to help.
> 
> Hmm, on third look, I've grovelled through the PHP for ACID 0.9.6b11
> (since that was in the snort CVS) and I see that ACID creates some tables,
> as well, one of which is missing an index that MySQL gets:

Also, do they run VACUUM ANALYZE after filling the table ?

PostgreSQL could choose very poor plans without it.

-------------
Hannu


pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Possible feature?
Next
From: Jan Wieck
Date:
Subject: Re: New SQL Datatype RECURRINGCHAR