Re: Update and cursor

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Update and cursor
Дата
Msg-id 22562.992958915@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Update and cursor  (Patrick COLLIN <patrick@felixfr.com>)
Список pgsql-general
Patrick COLLIN <patrick@felixfr.com> writes:
> I need to update 300,000 records with many tests on each before
> updating.
> I first tried a global update on each column, but I have not enough
> memory and swap to do that.

If this is 7.1, I'd be interested to see the query and the table
schemas.

If it isn't, time to update.  Older versions leak too much memory...

            regards, tom lane

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