Postgres Pro
Downloads
Home   >   mailing lists

Re: Select not using primary key index - Mailing list pgsql-general

From Doug McNaught
Subject Re: Select not using primary key index
Date
Msg-id m3it7zqha1.fsf@varsoon.denali.to
Whole thread Raw
In response to Select not using primary key index  (Sergio Freue <sfreue@yahoo.com>)
List pgsql-general
Tree view 
Sergio Freue <sfreue@yahoo.com> writes:

> I'm trying to run a simple query on a big (1,500,000 rows) table and
> I'm getting bad performance.

What version are you using?  7.2 keeps much better statistics for query
planning than 7.1.

-Doug
--
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Question about function
Next
From: Doug McNaught
Date:
Subject: Re: order by a XML column