| knowledge-database (beta) |
 |
Current group: pgsql.performance
Re: index scan of whole table, can't see why
| andrew at pillette.com | | Ragnar Hafstaš |
|
|
| | From: | andrew at pillette.com | | Subject: | Re: index scan of whole table, can't see why | | Date: | Wed, 19 Jan 2005 21:00:32 -0800 |
|
|
 | 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.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
| | From: | Ragnar Hafstaš | | Subject: | Re: index scan of whole table, can't see why | | Date: | Thu, 20 Jan 2005 09:23:58 +0000 |
|
|
| 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
|
|
|
| | |
|
 |