Efficient use of space in large table?
От | Josh Jore |
---|---|
Тема | Efficient use of space in large table? |
Дата | |
Msg-id | Pine.BSO.4.44.0207042126010.18711-100000@kitten.greentechnologist.org обсуждение исходный текст |
Ответы |
Re: Efficient use of space in large table?
|
Список | 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
В списке pgsql-general по дате отправления: