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 > [EMAIL PROTECTED]
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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
