Re: Postgresql performance

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Enix Empreendimentos e Construções "Ltda(dot)" <contato(at)enix(dot)com(dot)br>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgresql performance
Date: 2003-03-12 21:45:52
Message-ID: 1047505552.55840.56.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rbt(dot)ca>

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Max Baker 2003-03-12 22:38:11 speeding up COUNT and DISTINCT queries
Previous Message Chad Thompson 2003-03-12 21:38:16 Re: Postgresql performance