Re: Faster data type for one-length values

Поиск
Список
Период
Сортировка
От Lew
Тема Re: Faster data type for one-length values
Дата
Msg-id T_mdnSjYV9ldFfzbnZ2dnUVZ_tfinZ2d@comcast.com
обсуждение исходный текст
Ответ на Re: Faster data type for one-length values  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Список pgsql-general
Ron Mayer wrote:
> Alvaro Herrera wrote:
>> André Volpato wrote:
>>
>>> The ammount of space saved seems pretty clear to me.
>> Yeah, zero most of the time due to alignment.
>
> So trading off more I/O for less CPU?
>
> I wonder if for any I/O bound database servers
> it might be worth packing tightly rather than
> aligning indexes on one-byte data.

The OP didn't say one-byte data, they said one-char data.

--
Lew

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

Предыдущее
От: Lew
Дата:
Сообщение: Re: Multiple customers sharing one database?
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Multiple customers sharing one database?