Re: CREATE DATABASE on the heap with PostgreSQL?

-----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-----