From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | jihuang <jihuang(at)iis(dot)sinica(dot)edu(dot)tw> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, Albretch <lbrtchx(at)hotmail(dot)com> |
Subject: | Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL? |
Date: | 2004-06-07 09:09:09 |
Message-ID: | 40C430B5.9010300@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
jihuang wrote:
| May Users forcely assign a table / database / cluster storage in RAM
| purely ?
NO.
| or a in-directly-way , like making a RAM-Disk-Device and assign this
| device as a postgreSQL cluster?
YES.
| I think this feature will push a lot High-Performance usage ,
| any suggestion ?
I don't think you'll obtain this performance increase. You can write your own
script that before postgres start:
1) Create the RAM disk
2) Copy the table in memory
3) Create the link between the old location to the new one
and after stop postgres:
1) copy the table from RAM to DISK
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAxDC07UpzwH2SGd4RAm3KAJ9HFgvTSqXSGCh3Xx2n6+Mfqb7AcQCgzWht
CeFGnUTQrD9AWOTvwdkVr0A=
=evpH
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2004-06-07 09:28:34 | Re: pg_dump and tsearch2 |
Previous Message | Együd Csaba | 2004-06-07 08:38:27 | pg_dump, bytea, dump order questions |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-06-07 09:23:49 | Re: serverlog function |
Previous Message | Zeugswetter Andreas SB SD | 2004-06-07 08:04:50 | Re: Why hash indexes suck |