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

From andrew@pillette.com
Subject Re: index scan of whole table, can't see why
Date
Msg-id 200501200500.j0K50W508121@pillette.com
Whole thread Raw
In response to index scan of whole table, can't see why  ("Dan Langille" <dan@langille.org>)
Responses Re: index scan of whole table, can't see why
List pgsql-performance
This is a multi-part message in MIME format.

--bound1106197232
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Let's see if I have been paying enough attention to the SQL gurus. The planner is making a different estimate of how
manydeprecated<>'' versus how many broken <> ''. I would try SET STATISTICS to a larger number on the ports table, and
re-analyze.

--bound1106197232--

pgsql-performance by date:

Previous
From: Gustavo Franklin Nóbrega
Date:
Subject: Tips and tunning for pgsql on HP-UX PA-RISC (RP3410)
Next
From: William Yu
Date:
Subject: Re: Tips and tunning for pgsql on HP-UX PA-RISC (RP3410)