Thread: PostgreSQL equivalent to MySQL's HEAP tables?

Hi gang,

I have a table with three columns but many rows, that will constantly be
updated and selected.  The MySQL way is to create a HEAP table, or
basically a table that is stored only in RAM.

How shall I do this in PostgreSQL?  Is there a better way?

-- Mitch, loving 8.0.0 beta1

Mitch Pirtle wrote:
> I have a table with three columns but many rows, that will constantly
> be updated and selected.  The MySQL way is to create a HEAP table, or
> basically a table that is stored only in RAM.
>
> How shall I do this in PostgreSQL?  Is there a better way?

Use a ramdisk.  PostgreSQL only has one storage engine.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/