Re: Postgresql DB on a live cd

Alle 09:47, giovedì 20 novembre 2003, Ron Mayer ha scritto:

> One thing I don't think I saw mentioned yet....I think certain queries
> create temporary tables (or at least use some temporary space) so
>    ..../base/[whatevernumber]/pgsql_tmp
> should be a symlink to something on the ramdisk as well.
>
> (Kinda off-topic -- anecdotally it feels to me that some queries
> go faster if I put /pgsql_tmp on a different device & disk controller.
> If I verify this I'll post results to perform)
>
>    Ron Mayer
>    rm_pg@cheapcomplexdevices.com

Hi, ron

Sorry, yesterday I was out for working.

Ye, pgsql/data/base is in ramdisk.

I have got to launch my live cd. After resetting pg_xlog,
the pgsql dir is only 80MB (from 200MB).

The requirements to run the live cd are now to 256MB RAM (sigh!!).

Regards

Lucio