> Is the performance of the mentioned Postgresql version much slower than the
Somewhat, but not significantly.
Have you run VACUUM?
Have you run ANALYZE?
What does EXPLAIN ANALYZE <query> output for the slow queries?
If performance is still poor after the first 2, send the results of
EXPLAIN here and we'll tell you which index you're missing ;)
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
In response to
pgsql-performance by date
|Next:||From: Max Baker||Date: 2003-03-12 22:38:11|
|Subject: speeding up COUNT and DISTINCT queries|
|Previous:||From: Chad Thompson||Date: 2003-03-12 21:38:16|
|Subject: Re: Postgresql performance|