Re: Full statement logging problematic on larger machines?

Поиск
Список
Период
Сортировка
От Frank Joerdens
Тема Re: Full statement logging problematic on larger machines?
Дата
Msg-id 7d10d2df0903201201x470bdbb9gfdee702a4157f31b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Full statement logging problematic on larger machines?  (Laurent Laborde <kerdezixe@gmail.com>)
Список pgsql-performance
On Thu, Mar 12, 2009 at 9:32 PM, Laurent Laborde <kerdezixe@gmail.com> wrote:
> On Wed, Mar 11, 2009 at 11:42 PM, Frank Joerdens <frank@joerdens.de> wrote:
>>
>> effective_cache_size            = 4GB
>
> Only 4GB with 64GB of ram ?

I'd been overly cautious lately with config changes as it's been
difficult to argue for downtime and associated service risk. Changed
it to 48 GB now since it doesn't require a restart which I'd missed.
Thanks for spotting!

Regards,

Frank

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

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: Proposal of tunable fix for scalability of 8.4
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Need help with one query