Re: PostgreSQL equivalent to MySQL's HEAP tables?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Mitch Pirtle <mitchy(at)spacemonkeylabs(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PostgreSQL equivalent to MySQL's HEAP tables?
Date: 2004-08-15 18:52:39
Message-ID: 200408152052.39163.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Martin J. Brown, Jr. 2004-08-16 07:30:59 Re: can't authenticate pg admin
Previous Message Mitch Pirtle 2004-08-15 14:18:51 PostgreSQL equivalent to MySQL's HEAP tables?