Re: Index Scans become Seq Scans after VACUUM ANALYSE
От | Michael Loftis |
---|---|
Тема | Re: Index Scans become Seq Scans after VACUUM ANALYSE |
Дата | |
Msg-id | 3CBD9096.1060203@wgops.com обсуждение исходный текст |
Ответ на | Re: Index Scans become Seq Scans after VACUUM ANALYSE (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | 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 >
В списке pgsql-hackers по дате отправления: