Re: Minimizing disk space - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Minimizing disk space
Date
Msg-id dcc563d11001060935s32a285d6gfb5e8e01b6f7b187@mail.gmail.com
Whole thread Raw
In response to Minimizing disk space  (Adrian von Bidder <avbidder@fortytwo.ch>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Minimizing disk space
Next
From: benoît carpentier
Date:
Subject: [ANNOUNCE] Benetl, a free ETL tool for files using postgreSQL, is out in version 3.3