Re: Postgresql performance - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Postgresql performance
Date
Msg-id 1047505552.55840.56.camel@jester
Whole thread Raw
In response to Postgresql performance  (Enix Empreendimentos e Construções Ltda.<contato@enix.com.br>)
List pgsql-performance
> Is the performance of the mentioned Postgresql version much slower than the
> 7.3.1?

Somewhat, but not significantly.

Standard questions:

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@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment

pgsql-performance by date:

Previous
From: "Chad Thompson"
Date:
Subject: Re: Postgresql performance
Next
From: Max Baker
Date:
Subject: speeding up COUNT and DISTINCT queries