From: | <mail(at)iond(dot)it> |
---|---|
To: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Postgresql DB on a live cd |
Date: | 2003-11-21 10:05:09 |
Message-ID: | 200311211105.09738.mail@iond.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)cheapcomplexdevices(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | alvaro | 2003-11-21 13:05:48 | Problem doing pg_dumpall |
Previous Message | Jean Huveneers | 2003-11-21 07:06:30 | Re: Backup/Recovery (BR) question |