Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?

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

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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