Re: How to keep a table in memory?

Поиск
Список
Период
Сортировка
От Devrim GÜNDÜZ
Тема Re: How to keep a table in memory?
Дата
Msg-id 1194922039.6310.51.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: How to keep a table in memory?  (Robert Treat <xzilla@users.sourceforge.net>)
Ответы Re: How to keep a table in memory?  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
Hi,

On Mon, 2007-11-12 at 21:15 -0500, Robert Treat wrote:
> > 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

IIRC, ramfs are not that good for database use: If you want to extend
its size, you have to stop the database instance -- which is not
considered good.

Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Adjust script to be consistent (thanks Tom for the fix).
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: How to keep a table in memory?