Re: Log full with gigabyes of CurTransactionContex

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Log full with gigabyes of CurTransactionContex
Дата
Msg-id 16564.1245079425@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Log full with gigabyes of CurTransactionContex  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
Ответы Re: Log full with gigabyes of CurTransactionContex  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
Список pgsql-admin
=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com> writes:
> We have increased shared buffers to 2.5GB (linux kernels allows us reach
> this level) and lowered work_mem to 500MB.

You are apparently unclear on the concept.  Pushing the database to the
limit of the available address space is probably going to result in
failures.  Redistributing a set of overoptimistic parameters into a
different set of overoptimistic parameters will not fix this.

            regards, tom lane

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

Предыдущее
От: Iñigo Martinez Lasala
Дата:
Сообщение: Re: Log full with gigabyes of CurTransactionContex
Следующее
От: Gurjeet Singh
Дата:
Сообщение: Re: Log full with gigabyes of CurTransactionContex