Re: Odd out of memory problem.

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Odd out of memory problem.
Дата
Msg-id CAM-w4HOxV-OUd9CSgmeeYvau0gSkZ18Enf+L9TdgyUfs7TGEKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Odd out of memory problem.  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Odd out of memory problem.
Список pgsql-hackers
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?

--
greg


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: patch: autocomplete for functions
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Odd out of memory problem.