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

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: 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 21:03:02
Message-ID: 200902181303.02485@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 18 February 2009, Mike Christensen <imaudi(at)comcast(dot)net> wrote:
>
> ERROR: could not extend relation 1663/41130/41177: No space left on
> device HINT: Check free disk space.

> It seems to me there's some sort of "max table size" before you have to
> allocate more space on the disk, however I can't seem to find where
> these settings are and how to allow millions of rows to be inserted into
> a table without having to vacuum every few million rows..

The error indicates that your file system is full. It's not a PostgreSQL
problem. Hence the "hint".

--
A hybrid Escalade is missing the point much in the same way that having a
diet soda with your extra large pepperoni pizza is missing the point.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-02-18 21:03:28 Re: When adding millions of rows at once, getting out of disk space errors
Previous Message Mark Roberts 2009-02-18 21:02:30 Re: When adding millions of rows at once, getting out of disk space errors