Re: CREATE DATABASE on the heap with PostgreSQL? - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: CREATE DATABASE on the heap with PostgreSQL?
Date
Msg-id 40C430B5.9010300@bigfoot.com
Whole thread Raw
In response to Re: CREATE DATABASE on the heap with PostgreSQL?  (jihuang <jihuang@iis.sinica.edu.tw>)
List 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-----


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Why hash indexes suck
Next
From: Andreas Pflug
Date:
Subject: Re: serverlog function