fixed size columns

From: elein <elein(at)sbcglobal(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: elein(at)varlena(dot)com
Subject: fixed size columns
Date: 2003-04-30 00:35:31
Message-ID: 200304300041.h3U0fWBU044210@pimout1-ext.prodigy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have a very long, very narrow table that is taking up a few gigabytes.
The table is defined with varchar(n) fields and some character(n) fields.
I am assuming that the majority of all fields are filled.

Are these rows being stored on disk as aligned varlenas? Can I squish out some
space by arranging the columns to groups of 8 bytes? Or is each column
aligned separately on a new 8 byte boundary? Or is this a futile exercise?

thanks,
elein

--
----------------------------------------------------------------------------------------
elein(at)varlena(dot)com Database Consulting www.varlena.com
I have always depended on the [QA] of strangers.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Kirkwood 2003-04-30 01:26:05 Re: qsort (was Re: Solaris)
Previous Message Bruce Momjian 2003-04-30 00:26:45 Re: qsort (was Re: Solaris)