Re: Page Size in Future Releases

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема Re: Page Size in Future Releases
Дата
Msg-id 200303230946.41441.mweilguni@sime.com
обсуждение исходный текст
Ответ на Re: Page Size in Future Releases  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Am Samstag, 22. März 2003 01:15 schrieb Tom Lane:
> "Kendrick C. Wilson" <kendrick_wilson@hotmail.com> writes:
> > Will a increase in the size of a data page increase performance of a
> > database with large records?
>
> Probably not; in fact the increased WAL overhead could make it a net
> loss.  But feel free to try changing BLCKSZ to see how it works for you.

I've several database with 32KB and 8KB, and though the results are not really comparable due to slight different
hardware,I've the feeling that 8KB buffers work best in most cases. The only difference I noticed are large objects
whichseem to work slightly better with larger sizes. 

Regards,
    Mario Weilguni


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

Предыдущее
От: Andrew McMillan
Дата:
Сообщение: Re: Make PGSQL faster
Следующее
От: bsamwel@xs4all.nl
Дата:
Сообщение: Slow update of indexed column with many nulls