Re: BUG #2225: Backend crash -- BIG table

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: BUG #2225: Backend crash -- BIG table
Дата
Msg-id 20060204220647.GB15063@wolff.to
обсуждение исходный текст
Ответ на Re: BUG #2225: Backend crash -- BIG table  (Patrick Rotsaert <patrick.rotsaert@arrowup.be>)
Список pgsql-bugs
On Fri, Feb 03, 2006 at 19:38:04 +0100,
  Patrick Rotsaert <patrick.rotsaert@arrowup.be> wrote:
>
> I have 5.1GB of free disk space. If this is the cause, I have a
> problem... or is there another way to extract (and remove) duplicate rows?

How about processing a subset of the ids in one pass and then may make
multiple passes to check all of the ids. As long as you don't have to use
too small of chunks, this might work for you.

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

Предыдущее
От: "HOBY"
Дата:
Сообщение: BUG #2238: Query failed: ERROR
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #2236: extremely slow to get unescaped bytea data from db