PostgreSQL equivalent to MySQL's HEAP tables?

From: Mitch Pirtle <mitchy(at)spacemonkeylabs(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL equivalent to MySQL's HEAP tables?
Date: 2004-08-15 14:18:51
Message-ID: 411F70CB.6040505@spacemonkeylabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2004-08-15 18:52:39 Re: PostgreSQL equivalent to MySQL's HEAP tables?
Previous Message Grega Bremec 2004-08-15 12:16:16 Re: Pseudo-Off-topic-survey: Opinions about future of Postgresql(MySQL)?