Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL equivalent to MySQL's HEAP tables? - Mailing list pgsql-admin

From Mitch Pirtle
Subject PostgreSQL equivalent to MySQL's HEAP tables?
Date
Msg-id 411F70CB.6040505@spacemonkeylabs.com
Whole thread Raw
Responses Re: PostgreSQL equivalent to MySQL's HEAP tables?
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Grega Bremec
Date:
Subject: Re: Pseudo-Off-topic-survey: Opinions about future of Postgresql(MySQL)?
Next
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL equivalent to MySQL's HEAP tables?