Re: index scan of whole table, can't see why

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: andrew(at)pillette(dot)com
Cc: Dan Langille <dan(at)langille(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: index scan of whole table, can't see why
Date: 2005-01-20 09:23:58
Message-ID: 1106213038.22416.10.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 2005-01-19 at 21:00 -0800, andrew(at)pillette(dot)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

In response to

Browse pgsql-performance by date

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