Re: Postgresql DB on a live cd

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: Whole Thread | Raw Message | 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

In response to

Browse pgsql-admin by date

  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