Re: Minimizing disk space

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Minimizing disk space
Дата
Msg-id dcc563d11001060935s32a285d6gfb5e8e01b6f7b187@mail.gmail.com
обсуждение исходный текст
Ответ на Minimizing disk space  (Adrian von Bidder <avbidder@fortytwo.ch>)
Список pgsql-general
On Wed, Jan 6, 2010 at 8:39 AM, Adrian von Bidder <avbidder@fortytwo.ch> wrote:
> Howdy!
> With our test dump, the db (after import) is ca. 300M on disk, ca. half in
> WAL files (pg_xlog.)  If I could mostly get rid of the WAL (keep it to a
> bare minimum and run pg without fsync, something like that), the remaining
> 160 to 180M would be ok.
>
> Next thing would be: are there tunables (compile time?) to minimize the
> actual size of the rows?
>
> Your input is valued, thanks in advance.

Have you looked at firebird and / or sqllite?  They're both far better
suited for this type of application.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Minimizing disk space
Следующее
От: benoît carpentier
Дата:
Сообщение: [ANNOUNCE] Benetl, a free ETL tool for files using postgreSQL, is out in version 3.3