| 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.
| 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 |