Re: 8rc2 & BLCKSZ

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8rc2 & BLCKSZ
Дата
Msg-id 20322.1103749490@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 8rc2 & BLCKSZ  (Vivek Khera <khera@kcilink.com>)
Ответы Re: 8rc2 & BLCKSZ  (Mario Weilguni <mweilguni@sime.com>)
Список pgsql-performance
Vivek Khera <khera@kcilink.com> writes:
> One of the suggestions handed to me a long time ago for speeding up PG
> on FreeBSD was to double the default blocksize in PG.  I tried it, but
> found not a significant enough speed up to make it worth the trouble
> to remember to patch every version of Pg during the upgrade path (ie,
> 7.4.0 -> 7.4.2 etc.)  Forgetting to do that would be disastrous!

Not really --- the postmaster will refuse to start if the BLCKSZ shown
in pg_control doesn't match what is compiled in.  I concur though that
there may be no significant performance gain.  For some workloads there
may well be a performance loss from increasing BLCKSZ.

            regards, tom lane

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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: 8rc2 & BLCKSZ
Следующее
От: Litao Wu
Дата:
Сообщение: Re: Why so much time difference with a same query/plan?