Postgres Pro
Downloads
Home   >   mailing lists

Re: index scan of whole table, can't see why - Mailing list pgsql-performance

From Ragnar Hafstað
Subject Re: index scan of whole table, can't see why
Date
Msg-id 1106213038.22416.10.camel@localhost.localdomain
Whole thread Raw
In response to Re: index scan of whole table, can't see why  (andrew@pillette.com)
List pgsql-performance
Tree view 
On Wed, 2005-01-19 at 21:00 -0800, andrew@pillette.com wrote:
> Let's see if I have been paying enough attention to the SQL gurus.
> The planner is making a different estimate of how many deprecated<>'' versus how many broken <> ''.
> I would try SET STATISTICS to a larger number on the ports table, and re-analyze.

that should not help, as the estimate is accurate, according to the
explain analyze.

gnari

pgsql-performance by date:

Previous
From: William Yu
Date:
Subject: Re: Tips and tunning for pgsql on HP-UX PA-RISC (RP3410)
Next
From: Ragnar Hafstað
Date:
Subject: Re: index scan of whole table, can't see why