Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: select on 1milion register = 6s
- From: Craig James <craig_james(at)emolecules(dot)com>
- To: Bruno Rodrigues Siqueira <bruno(at)ravnus(dot)com>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: select on 1milion register = 6s
- Date: Sat, 28 Jul 2007 12:59:26 -0700
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. Craig
- Follow-Ups:
- RES: select on 1milion register = 6s
- From: Bruno Rodrigues Siqueira
- RES: select on 1milion register = 6s
- References:
- select on 1milion register = 6s
- From: Bruno Rodrigues Siqueira
- select on 1milion register = 6s
- Prev by Date: select on 1milion register = 6s
- Next by Date: Re: select on 1milion register = 6s
- Previous by thread: select on 1milion register = 6s
- Next by thread: RES: select on 1milion register = 6s
- Indexes: