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

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: 2007-07-28 19:59:26
Message-ID: 46ABA01E.8000802@emolecules.com (view raw or flat)
Thread:
Lists: pgsql-performance
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



In response to

Responses

pgsql-performance by date

Next:From: Craig JamesDate: 2007-07-28 20:06:02
Subject: Re: Slow query with backwards index scan
Previous:From: Hervé PiedvacheDate: 2007-07-28 19:56:58
Subject: Re: select on 1milion register = 6s

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