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.
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) |