Re: Converting MySQL tinyint to PostgreSQL - Mailing list pgsql-general

From Ron Mayer
Subject Re: Converting MySQL tinyint to PostgreSQL
Date
Msg-id 42D51C1F.8070506@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Converting MySQL tinyint to PostgreSQL  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Converting MySQL tinyint to PostgreSQL
List pgsql-general
Martijn van Oosterhout wrote:
>
> Well, you get another issue, alignment. If you squeeze your string
> down, the next field, if it is an int or string, will get padded to a
> multiple of 4 negating most of the gains. Like in C structures, there
> is padding to optimise access.

Anecdotally I hear at least as many people say that their database
is more I/O bound than CPU bound; and it seems that adding bytes
for alignment is a way of reducing CPU for more disk I/O.

I guess unaligned access so expensive that it makes up for the extra i/o?

pgsql-general by date:

Previous
From: Gnanavel S
Date:
Subject: Re: INSERT INTO from a SELECT query
Next
From: "David Esposito"
Date:
Subject: Re: index bloat