Re: Index Scans become Seq Scans after VACUUM ANALYSE
Michael Loftis <mloftis@wgops.com>
From: Michael Loftis <mloftis@wgops.com>
To: pgsql-hackers@postgresql.org
Date: 2002-04-17T15:11:18Z
Lists: pgsql-hackers
Y'all are having entirely too much fun with this :P Though the headling ... 'PostgreSQL with its proprietary bitch-rant-rating query planner storms the DB front.' does have a certain...entertainment value. Thomas Lockhart wrote: >... > >>Weighing these factors, perhaps once we get one or two complaining about >>postgresql using an index vs 20 complaining about not using an index, then >>the optimizer values have reached a good compromise :). But maybe the ratio >>should be 1 vs 100? >> > >:) > >So we should work on collecting those statistics, rather than statistics >on data. What do you think Tom; should we work on a "mailing list based >planner" which adjusts numbers from, say, a web site? That is just too >funny :))) > > - Thomas > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >