Re: BLCKSZ

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BLCKSZ
Дата
Msg-id 29518.1133794958@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BLCKSZ  (Olleg Samoylov <olleg_s@mail.ru>)
Ответы Re: BLCKSZ  (Olleg <olleg_s@mail.ru>)
Список pgsql-performance
Olleg Samoylov <olleg_s@mail.ru> writes:
> I try to test this. Linux, memory page 4kb, disk page 4kb. I set BLCKSZ
> to 4kb. I get some performance improve, but not big, may be because I
> have 4Gb on test server (amd64).

It's highly unlikely that reducing BLCKSZ is a good idea.  There are bad
side-effects on the maximum index entry size, maximum number of tuple
fields, etc.  In any case, when you didn't say *what* you tested, it's
impossible to judge the usefulness of the change.

            regards, tom lane

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

Предыдущее
От: "Markus Wollny"
Дата:
Сообщение: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0