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

From: andrew(at)pillette(dot)com
To: "Dan Langille" <dan(at)langille(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: index scan of whole table, can't see why
Date: 2005-01-20 05:00:32
Message-ID: 200501200500.j0K50W508121@pillette.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 many deprecated<>'' versus how many broken <> ''. I would try SET STATISTICS to a larger number on the ports table, and re-analyze.

--bound1106197232--

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message William Yu 2005-01-20 09:21:09 Re: Tips and tunning for pgsql on HP-UX PA-RISC (RP3410)
Previous Message Gustavo Franklin Nóbrega 2005-01-20 04:05:26 Tips and tunning for pgsql on HP-UX PA-RISC (RP3410)