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

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 (view raw or flat)
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

pgsql-performance by date

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

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