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 Tom Lane
Subject Re: When adding millions of rows at once, getting out of disk space errors
Date
Msg-id 25716.1234990614@sss.pgh.pa.us
Whole thread Raw
In response to When adding millions of rows at once, getting out of disk space errors  (Mike Christensen <imaudi@comcast.net>)
List pgsql-general
Tree view 
Mike Christensen <imaudi@comcast.net> writes:
> I'm doing some perf testing and need huge amounts of data.  So I have a
> program that is adding data to a few tables ranging from 500,000 to 15M
> rows.  The program is just a simply C# program that blasts data into the
> DB, but after about 3M rows or so I get an errror:

> ERROR:  could not extend relation 1663/41130/41177: No space left on device
> HINT:  Check free disk space.

Not to put too fine a point on it, but maybe you need to buy a bigger
disk.

            regards, tom lane

pgsql-general by date:

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