Re: How to keep a table in memory?

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: How to keep a table in memory?
Дата
Msg-id 47390E8D.2030701@commandprompt.com
обсуждение исходный текст
Ответ на Re: How to keep a table in memory?  (Robert Treat <xzilla@users.sourceforge.net>)
Ответы Re: How to keep a table in memory?  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Adjust script to be consistent (thanks Tom for the fix).
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Adjust script to be consistent (thanks Tom for the fix).