Re: Index oddity
От
Rod Taylor
Тема
Re: Index oddity
Дата
Msg-id
1086833876.2539.156.camel@jester
Ответ на
Re: Index oddity (Christopher Kings-Lynne)
Список
Дерево обсуждения
Index oddity ken <southerland@samsixedd.com>
Re: Index oddity Rod Taylor <pg@rbt.ca>
Re: Index oddity ken <southerland@samsixedd.com>
Re: Index oddity Rod Taylor <pg@rbt.ca>
Re: Index oddity ken <southerland@samsixedd.com>
Re: Index oddity Rod Taylor <pg@rbt.ca>
Re: Index oddity ken <southerland@samsixedd.com>
Re: Index oddity Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Index oddity Rod Taylor <pg@rbt.ca>
Re: Index oddity Mark Kirkwood <markir@coretech.co.nz>
Re: Index oddity "Joshua D. Drake" <jd@commandprompt.com>
Re: Index oddity Tom Lane <tgl@sss.pgh.pa.us>
Re: Index oddity (still) ken <southerland@samsixedd.com>
Re: Index oddity (still) Tom Lane <tgl@sss.pgh.pa.us>
On Wed, 2004-06-09 at 21:45, Christopher Kings-Lynne wrote: > > If I take away the diagonalSize condition in my query I find that there > > are 225 rows that satisfy the other conditions. 155 of these have a > Maybe you should drop your random_page_cost to something less than 4, > eg. 3 or even 2... The big problem is a very poor estimate (off by a couple orders of magnitude). I was hoping someone with more knowledge in fixing those would jump in.
В списке pgsql-performance по дате отправления
