Re: Odd out of memory problem.

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Odd out of memory problem.
Дата
Msg-id 4F70A059.5070601@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Odd out of memory problem.  (Greg Stark <stark@mit.edu>)
Ответы Re: Odd out of memory problem.
Список pgsql-hackers
On 26.03.2012 19:51, Greg Stark wrote:
> On Mon, Mar 26, 2012 at 5:41 PM, Andrew Dunstan<andrew@dunslane.net>  wrote:
>>         Combo CIDs: 755490840 total in 100 blocks; 5161072 free (381
>>    chunks); 750329768 used
>
> I think you'll have to catch Heikki's attention to get a good answer to this.
>
> Is it possible this job is inserting and then updating (or deleteing)
> the row it just inserted and doing a large number of such
> insert/update operations all within the same transaction? Or perhaps
> it's updating the same row over and over again?

.. and all that in different subtransactions.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Odd out of memory problem.
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Odd out of memory problem.