Re: Query much faster with enable_seqscan=0
От
Jesper Krogh
Тема
Re: Query much faster with enable_seqscan=0
Дата
Msg-id
4C98FEA2.8030607@krogh.cc
Ответ на
Список
Дерево обсуждения
Query much faster with enable_seqscan=0 Ogden <lists@darkstatic.com>
Re: Query much faster with enable_seqscan=0 Tom Lane <tgl@sss.pgh.pa.us>
Re: Query much faster with enable_seqscan=0 Ogden <lists@darkstatic.com>
Re: Query much faster with enable_seqscan=0 Samuel Gendler <sgendler@ideasculptor.com>
Re: Query much faster with enable_seqscan=0 Robert Haas <robertmhaas@gmail.com>
Re: Query much faster with enable_seqscan=0 Kenneth Marshall <ktm@rice.edu>
Re: Query much faster with enable_seqscan=0 Ogden <lists@darkstatic.com>
Re: Query much faster with enable_seqscan=0 Jesper Krogh <jesper@krogh.cc>
Re: Query much faster with enable_seqscan=0 Ogden <lists@darkstatic.com>
Re: Query much faster with enable_seqscan=0 "Joshua D. Drake" <jd@commandprompt.com>
Re: Query much faster with enable_seqscan=0 "Joshua D. Drake" <jd@commandprompt.com>
Re: Query much faster with enable_seqscan=0 Greg Smith <greg@2ndquadrant.com>
Re: Query much faster with enable_seqscan=0 Tom Lane <tgl@sss.pgh.pa.us>
Re: Query much faster with enable_seqscan=0 Ogden <lists@darkstatic.com>
Re: Query much faster with enable_seqscan=0 Ogden <lists@darkstatic.com>
Re: Query much faster with enable_seqscan=0 Robert Haas <robertmhaas@gmail.com>
Re: Query much faster with enable_seqscan=0 Scott Carey <scott@richrelevance.com>
On 2010-09-21 20:21, Ogden wrote: > I assume you mean random_page_cost? It is currently set to 4.0 - is it better to increase or decrease this value? > Should be lowered to a bit over seq_page_cost.. and more importantly.. you should make sure that you have updated your statistics .. run "ANALYZE"; -- Jesper
В списке pgsql-performance по дате отправления
