Re: Index Scans become Seq Scans after VACUUM ANALYSE - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date
Msg-id Pine.LNX.4.30.0204171428300.690-100000@peter.localdomain
Whole thread Raw
In response to Re: Index Scans become Seq Scans after VACUUM ANALYSE  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
mlw writes:

> Adding huristics, such as weighting for index scans, is not making the planner
> stupider. It is making it smarter and more flexable.

If life was as simple as index or no index then this might make some
sense.  But in general the planner has a whole bunch of choices of join
plans, sorts, scans, and the cost of an individual index scan is hidden
down somewhere in the leaf nodes, so you can't simply say that plans of
type X should be preferred when the cost estimates are close.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE
Next
From: mlw
Date:
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE