| 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: | Whole Thread | Raw Message | 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) |