Postgres Pro
Downloads
Home   >   mailing lists

Re: Deleting millions of rows - Mailing list pgsql-performance

From David Wilson
Subject Re: Deleting millions of rows
Date
Msg-id e7f9235d0902021220s7309da0es1c2bcec1e6f42eaa@mail.gmail.com
Whole thread Raw
In response to Deleting millions of rows  (Brian Cox <brian.cox@ca.com>)
List pgsql-performance
Tree view 
On Mon, Feb 2, 2009 at 1:17 PM, Brian Cox <brian.cox@ca.com> wrote:
> I'm using 8.3.5. Table ts_defects has 48M rows. Through psql: delete from
> ts_defects;
> Result: out of memory/Can't allocate size: 32

Is this table the target of any foreign keys?

--
- David T. Wilson
david.t.wilson@gmail.com

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Deleting millions of rows
Next
From: "Dave Dutcher"
Date:
Subject: Re: Deleting millions of rows