Re: How to keep a table in memory?

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