Re: how much ram do i give postgres?

Поиск
Список
Период
Сортировка
От Josh Close
Тема Re: how much ram do i give postgres?
Дата
Msg-id 4a0cafe2041019153557b65563@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how much ram do i give postgres?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: how much ram do i give postgres?  ("Gary Doades" <gpd@gpdnet.co.uk>)
Список pgsql-general
On Tue, 19 Oct 2004 17:42:16 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The short answer is no; the sweet spot for shared_buffers is usually on
> the order of 10000 buffers, and trying to go for "75% of RAM" isn't
> going to do anything except hurt.  For the long answer see the
> pgsql-performance list archives.
>
>                         regards, tom lane

Well, I didn't find a whole lot in the list-archives, so I emailed
that list whith a few more questions. My postgres server is just
crawling right now :(

-Josh

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

Предыдущее
От: Steven Klassen
Дата:
Сообщение: Re: reusing column labels in select
Следующее
От: pw
Дата:
Сообщение: Re: How do I recover from>> pg_xlog/0000000000000000 (log