Re: When adding millions of rows at once, getting out of disk space errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Christensen <imaudi(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: When adding millions of rows at once, getting out of disk space errors
Date: 2009-02-18 20:56:54
Message-ID: 25716.1234990614@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Christensen <imaudi(at)comcast(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-02-18 20:58:48 Re: Appending \o output instead of overwriting the output file
Previous Message Mike Christensen 2009-02-18 20:55:23 Re: When adding millions of rows at once, getting out of disk space errors