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

2004-06-07 Thread Albretch
Gaetano Mendola [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... If you access a table more frequently then other and you have enough RAM your OS will mantain that table on RAM, don't you think ? BTW if you trust on your UPS I'm sure you are able to create a RAM disk and place that

[HACKERS] CREATE DATABASE on the heap with PostgreSQL?

2004-06-06 Thread Albretch
DBMS like MySQL and hsqldb (the only two I know that can keep and process tables on the heap) have a CREATE DATABASE case in which the 'database' is specified to reside in memory, that is RAM. For some data handling cases for which persistence is not important, this is all you need. These types