PostgreSQL equivalent to MySQL's HEAP tables?

Поиск
Список
Период
Сортировка
Искать

PostgreSQL equivalent to MySQL's HEAP tables?

От:
Mitch Pirtle <mitchy@spacemonkeylabs.com>
Дата:
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

Re: PostgreSQL equivalent to MySQL's HEAP tables?

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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/

FAQ