Re: How to keep a table in memory?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem to configure pg8.3b2 w/ ossp-uuid-support on OS X
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Adjust script to be consistent (thanks Tom for the fix).