On 7/01/2010 11:27 PM, Adrian von Bidder wrote:
Heyho!
On Wednesday 06 January 2010 18.26:05 Joshua D. Drake wrote:
...
With this in mind: what can we tune to minimize diskspace (RAM-disk
space) usage?
[thanks to all for your input!]
Wow, here are some things but honestly Pg may not be the
Heyho!
On Wednesday 06 January 2010 18.26:05 Joshua D. Drake wrote:
...
> > With this in mind: what can we tune to minimize diskspace (RAM-disk
> > space) usage?
[thanks to all for your input!]
> Wow, here are some things but honestly Pg may not be the DB you are
> looking for.
Well, parts of
Adrian von Bidder wrote:
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.
Drop checkpoint_seg
On Wed, Jan 6, 2010 at 8:39 AM, Adrian von Bidder 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
> 1
On Wed, 2010-01-06 at 16:39 +0100, Adrian von Bidder wrote:
> Howdy!
>
> I'm currently in a MySQL -> PostgreSQL migration project (Go, go, go, ...
> shall I cc: slashdot, too? ;-)
>
> Part of this is in embedded context, where a (diskless) embedded computer
> runs from flash. Since we don't wa
Adrian von Bidder writes:
> 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.
checkpoint_s
Howdy!
I'm currently in a MySQL -> PostgreSQL migration project (Go, go, go, ...
shall I cc: slashdot, too? ;-)
Part of this is in embedded context, where a (diskless) embedded computer
runs from flash. Since we don't want to stress the flash too much, the db
is actually loaded from a dump at
