Postgres Pro
Downloads
Home   >   mailing lists

Re: When adding millions of rows at once, getting out of disk space errors - Mailing list pgsql-general

From Mark Roberts
Subject Re: When adding millions of rows at once, getting out of disk space errors
Date
Msg-id 1234990951.11148.324.camel@localhost
Whole thread Raw
In response to Re: When adding millions of rows at once, getting out of disk space errors  (Mike Christensen <imaudi@comcast.net>)
List pgsql-general
Tree view 
On Wed, 2009-02-18 at 12:55 -0800, Mike Christensen wrote:
> I have well over 50 gigs free on that drive..  I doubt it.

Are you sure the pg data directory is on the drive you think it is?  Are
you doing alot of deletes or are you merely inserting?  Are you doing
any sorting and therefore running out of temp space in your tmp
partition [supposition, I've run into something like this before, but
not specifically with Postgres].

-Mark

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Appending \o output instead of overwriting the output file
Next
From: Scott Marlowe
Date:
Subject: Re: When adding millions of rows at once, getting out of disk space errors