Re: Faster data type for one-length values - Mailing list pgsql-general

From Lew
Subject Re: Faster data type for one-length values
Date
Msg-id T_mdnSjYV9ldFfzbnZ2dnUVZ_tfinZ2d@comcast.com
Whole thread Raw
In response to Re: Faster data type for one-length values  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List 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 by date:

Previous
From: Lew
Date:
Subject: Re: Multiple customers sharing one database?
Next
From: Michael Glaesemann
Date:
Subject: Re: Multiple customers sharing one database?