Efficient use of space in large table?

From: Josh Jore <josh(at)greentechnologist(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Efficient use of space in large table?
Date: 2002-07-05 02:43:10
Message-ID: Pine.BSO.4.44.0207042126010.18711-100000@kitten.greentechnologist.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was just wondering - I've got two large tables and I was wondering
if there is anyway to shrink them somewhat. I imagined compression for
non-indexed columns or something. Is varchar or char more efficient than
text? I'm sort of just grasping at straws for something to get the data
smaller.

Josh

A size summary
relname | size | type
------------------------+-------+----------
sospeople | 599MB | table
sospeople_fn | 71MB | index
sospeople_ln | 73MB | index
sospeople_zip | 73MB | index
votes | 937MB | table

Table "sospeople"
Attribute | Type | Modifier
------------------+---------+---------------------
sosid | text | not null default ''
countyname | text | not null
firstname | text |
middlename | text |
lastname | text |
suffix | text |
homephone | text |
registrationdate | text |
birthyear | integer |
status | text |
precinctcode | text |
housenumber | text |
streetname | text |
unittype | text |
unit | text |
address2 | text |
city | text |
state | text |
zipcode | text |
Indices: sospeople_fn,
sospeople_ln,
sospeople_zip

Table "votes"
Attribute | Type | Modifier
------------+---------------+----------
sosid | character(10) |
electionid | integer |
votetype | character(1) |

Joshua b. Jore ; http://www.greentechnologist.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2002-07-05 03:17:25 Should next release by 8.0 (Was: Re: [GENERAL] I am being interviewed by OReilly )
Previous Message Justin Clift 2002-07-05 00:52:37 Re: I am being interviewed by OReilly