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

From Robert Treat
Subject Re: How to keep a table in memory?
Date
Msg-id 200711122115.01641.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: How to keep a table in memory?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: How to keep a table in memory?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: How to keep a table in memory?  (Devrim GÜNDÜZ <devrim@CommandPrompt.com>)
List pgsql-hackers
On Monday 12 November 2007 18:31, Andrew Dunstan wrote:
> 1. when someone replies to your post at the bottom, please don't put
> your reply at the top. It makes everything totally unreadable.
>

+1

> 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

> FYI, Postgres is know to be used successfully on some *extremely* heavy
> websites, without using tables pinned in memory.
>

+1

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem to configure pg8.3b2 w/ ossp-uuid-support on OS X
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Adjust script to be consistent (thanks Tom for the fix).