Re: Faster data type for one-length values

From: Lew <lew(at)nospam(dot)lewscanon(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Faster data type for one-length values
Date: 2007-06-02 15:12:00
Message-ID: T_mdnSjYV9ldFfzbnZ2dnUVZ_tfinZ2d@comcast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasbinder Singh Bali 2007-06-02 15:12:44 Re: Transactional DDL
Previous Message Tom Lane 2007-06-02 14:54:16 Re: Corruption of files in PostgreSQL