pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL equivalent to MySQL's HEAP tables?
2+ messages / 2 participants
[nested] [flat]

* PostgreSQL equivalent to MySQL's HEAP tables?
@ 2004-08-15 14:18  Mitch Pirtle <mitchy@spacemonkeylabs.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Mitch Pirtle @ 2004-08-15 14:18 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PostgreSQL equivalent to MySQL's HEAP tables?
@ 2004-08-15 18:52  Peter Eisentraut <peter_e@gmx.net>
  parent: Mitch Pirtle <mitchy@spacemonkeylabs.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2004-08-15 18:52 UTC (permalink / raw)
  To: Mitch Pirtle <mitchy@spacemonkeylabs.com>; 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/




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-08-15 18:52 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-15 14:18 PostgreSQL equivalent to MySQL's HEAP tables? Mitch Pirtle <mitchy@spacemonkeylabs.com>
2004-08-15 18:52 ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox