Re: BUG #2225: Backend crash -- BIG table - Mailing list pgsql-bugs

From Bruno Wolff III
Subject Re: BUG #2225: Backend crash -- BIG table
Date
Msg-id 20060204220647.GB15063@wolff.to
Whole thread Raw
In response to Re: BUG #2225: Backend crash -- BIG table  (Patrick Rotsaert <patrick.rotsaert@arrowup.be>)
List 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 by date:

Previous
From: "HOBY"
Date:
Subject: BUG #2238: Query failed: ERROR
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #2236: extremely slow to get unescaped bytea data from db