Re: 7.2.1 optimises very badly against 7.2

Поиск
Список
Период
Сортировка
От Jean-Luc Lachance
Тема Re: 7.2.1 optimises very badly against 7.2
Дата
Msg-id 3D2EEB79.F20AD831@nsd.ca
обсуждение исходный текст
Ответ на Re: 7.2.1 optimises very badly against 7.2  ("Sam Liddicott" <sam.liddicott@ananova.com>)
Ответы Re: 7.2.1 optimises very badly against 7.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Just curious,

Is the number of record per page and the number of key per page taken in
consideration?


Tom Lane wrote:
>
> "Sam Liddicott" <sam.liddicott@ananova.com> writes:
> > Do you feel the random page cost of 3 is good to solve this?
>
> For the moment, anyway.  There have been a couple of rounds of
> pgsql-hackers discussion about whether to lower the default value of
> random_page_cost, but so far no one has done any experiments that
> would be needed to establish a good new value.  (The current default
> of 4.0 is based on some old experiments I did.  I'm quite willing to
> accept that those experiments might have been flawed, but not willing
> to replace the number without seeing better experiments...)
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

В списке pgsql-general по дате отправления:

Предыдущее
От: Dmitry Tkach
Дата:
Сообщение: Re: [SQL] Please, HELP! Why is the query plan so wrong???
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: workaround for lack of REPLACE() function