Re: How to keep a table in memory? - Mailing list pgsql-hackers

From Devrim GÜNDÜZ
Subject Re: How to keep a table in memory?
Date
Msg-id 1194922039.6310.51.camel@localhost.localdomain
Whole thread Raw
In response to Re: How to keep a table in memory?  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: How to keep a table in memory?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Hi,

On Mon, 2007-11-12 at 21:15 -0500, Robert Treat wrote:
> > 2. you should investigate one or more of: pg_memcache, solid state
> > disk.
>
> you might also consider creating a tablespace on tmpfs or ramfs or
> something like pramfs

IIRC, ramfs are not that good for database use: If you want to extend
its size, you have to stop the database instance -- which is not
considered good.

Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Adjust script to be consistent (thanks Tom for the fix).
Next
From: Andrew Dunstan
Date:
Subject: Re: How to keep a table in memory?