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

From Joshua D. Drake
Subject Re: How to keep a table in memory?
Date
Msg-id 47390E8D.2030701@commandprompt.com
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?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Robert Treat wrote:
> 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

I give this a +/- 1. Yes extremely heavy websites can do this *but* they 
require extremely expensive hardware to do so.

Joshua D. Drake




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Adjust script to be consistent (thanks Tom for the fix).
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Adjust script to be consistent (thanks Tom for the fix).