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?  (Manfred Koizar <mkoi-pg@aon.at>)
Список 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 по дате отправления:

Предыдущее
От: Justin Clift
Дата:
Сообщение: Re: I am being interviewed by OReilly
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: I am being interviewed by OReilly