Bruno Rodrigues Siqueira wrote:
> Who can help me? My SELECT in a base with 1 milion register,
> using expression index = 6seconds…
Run your query using
EXPLAIN ANALYZE SELECT ... your query ...
and then post the results to this newsgroup. Nobody can help until they see the results of EXPLAIN ANALYZE. Also, include all other relevant information, such as Postgres version, operating system, amount of memory, and any changes you have made to the Postgres configuration file.
In response to
pgsql-performance by date
|Next:||From: Craig James||Date: 2007-07-28 20:06:02|
|Subject: Re: Slow query with backwards index scan|
|Previous:||From: Hervé Piedvache||Date: 2007-07-28 19:56:58|
|Subject: Re: select on 1milion register = 6s|