Re: Scaling further up

Поиск
Список
Период
Сортировка
От Matt Davies
Тема Re: Scaling further up
Дата
Msg-id 1079382515.405611f35f1c5@www.mattdavies.net
обсуждение исходный текст
Ответ на Re: Scaling further up  (Andrew Sullivan <ajs@crankycanuck.ca>)
Ответы Re: Scaling further up  (Stephen Robert Norris <srn@commsecure.com.au>)
Список pgsql-performance
Quoting Andrew Sullivan <ajs@crankycanuck.ca>:

> On Fri, Mar 12, 2004 at 06:25:48PM -0500, Anjan Dave wrote:
> > We upgraded from 8GB to 12GB RAM a month or so ago, but even in the
> > past, I've never seen the system exhaust on it's system cache (~6GB, in
> > 'top'), while it's swapping.
> >
> > Some one had mentioned why not have the entire DB in memory? How do I
> > configure that, for knowledge?
>
> You don't.  It'll automatically be in memory if (a) you have enough
> memory, (b) you don't have anything else on the machine using the
> memory, and (c) it's been read at least one time.

This is the preferred method, but you could create a memory disk if running
linux. This has several caveats, though.

1. You may have to recompile the kernel for support.
2. You must store the database on a hard drive partition during reboots.
3. Because of #2 this option is generally useful if you have static content that
is loaded to the MD upon startup of the system.

You could have some fancy methodology of shutting down the system and then
copying the data to a disk-based filesystem, but this is inherently bad since
at any moment a power outage would erase any updates changes.

The option is there to start with all data in memory, but in general, this is
probablt not what you want. Just an FYI.

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

Предыдущее
От: "Rosser Schwarz"
Дата:
Сообщение: atrocious update performance
Следующее
От: Mike Bridge
Дата:
Сообщение: Re: High CPU with 7.4.1 after running for about 2 weeks