DB on a ramdisk (was Re: Temporary, In-memory Postgres DB?)

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема DB on a ramdisk (was Re: Temporary, In-memory Postgres DB?)
Дата
Msg-id 4731ECA4.7020600@cox.net
обсуждение исходный текст
Ответ на Re: Temporary, In-memory Postgres DB?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: DB on a ramdisk (was Re: Temporary, In-memory Postgres DB?)
Re: DB on a ramdisk (was Re: Temporary, In-memory Postgres DB?)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 11/07/07 09:58, Tom Lane wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
>> On 11/07/07 09:03, Gauthier, Dave wrote:
>>> Is there such a thing as a temporary, probably in-memory, version of a
>>> Postgres DB?
>
>> If you have enough RAM, and your database is small enough, the OS
>> will eventually cache the whole thing.
>
> Or put it on a ramdisk filesystem.

But doesn't that just add more overhead and reduce the amount of
memory that the OS can cache things in?


- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHMeykS9HxQb37XmcRArErAJ47+9oq1/fTZZ4AXrLnL2qGo6E29gCgqVhP
DoZuWDTpWE4Rks3tjAWa0mQ=
=fuHr
-----END PGP SIGNATURE-----

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Следующее
От: rihad
Дата:
Сообщение: Re: prepared statements suboptimal?