Re: Any risk in increasing BLCKSZ to get larger tuples?

Поиск
Список
Период
Сортировка
От Elmar Haneke
Тема Re: Any risk in increasing BLCKSZ to get larger tuples?
Дата
Msg-id 39EFECB6.FBEC2EF2@haneke.de
обсуждение исходный текст
Ответ на Any risk in increasing BLCKSZ to get larger tuples?  (Philip Hallstrom <philip@adhesivemedia.com>)
Список pgsql-general
e40@iboats.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Steve Wolfe wrote:

>   Hmm... that doesn't seem quite right to me.  Whether it is compressed or
> not, the same amount of final data has to move across the system bus to the
> CPU for processing.

Thats correct as far as your disk is bottlenecked by the system bus
:-)

Elmar

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

Предыдущее
От: Ron Chmara
Дата:
Сообщение: Re: MySQL -> pgsql
Следующее
От: Claudio Jose Zanardi Grillo
Дата:
Сообщение: Re: prefer (+) oracle notation