Re: ERROR: out of free buffers: time to abort!

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: ERROR: out of free buffers: time to abort!
Дата
Msg-id 3E7647C8.4000807@selectacast.net
обсуждение исходный текст
Ответ на Re: ERROR: out of free buffers: time to abort!  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ERROR: out of free buffers: time to abort!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
> Joseph Shraibman <jks@selectacast.net> writes:
>
>>I upped the shared_buffers from 128 to 256 and I'm still getting the error.
>
>
> Hmph.  I wonder if you've got a bug there.  What PG version is this?

select version();
                                                  version

---------------------------------------------------------------------------------------------------------
  PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat
Linux 8.0 3.2-7)
(1 row)


> Is it possible that the update is hitting rows that have been recently
> updated in concurrent transactions?

Unlikely.  I run this cron job every day, and every day I get the same error.  The whole
thing should be pretty quick.



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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: copying between Postgres databases
Следующее
От: Kurt Overberg
Дата:
Сообщение: Tomcat/Struts/Pooling?/Memory Sizes