Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Loftis
Subject Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date
Msg-id 3CBD3DBE.4020001@wgops.com
Whole thread Raw
In response to Re: Index Scans become Seq Scans after VACUUM ANALYSE  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
My opinion.

Expose some of the cost factors via run-time settings (or start-time 
settings).

This would allow those who wanted to 'tweak' the planner to do so and 
those that felt the defaults were fine or didn't know to leave them alone.

Comments?

pgsql-hackers by date:

Previous
From: "Darko Prenosil"
Date:
Subject: plpq
Next
From: Michael Loftis
Date:
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE