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