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

From Mike Christensen
Subject Re: When adding millions of rows at once, getting out of disk space errors
Date
Msg-id 499D3066.10008@comcast.net
Whole thread Raw
In response to Re: When adding millions of rows at once, getting out of disk space errors  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: When adding millions of rows at once, getting out of disk space errors
List pgsql-general
Actually I'm writing emails on my Mac <g>

However, the Postgres service is running on my Windows 2003 machine..

The disk space issue turned out to be a disk quota which was easy to
solve.  Unfortunately, the fact it crashed Postgres and with a massive
transaction log left the server in a state where it wouldn't boot
anymore.  I was eventually able to fix it by resetting the transaction
log manually.  I'm hoping future versions of Postgres will handle this
scenario a lot better..

Mike

Grzegorz Jaśkiewicz wrote:
> I bet it is on windows (judging by html in that email), but if isn't:
> open a console and issue:
> watch -n 0.5 df -h
> and run that insert again ;)
>
>

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: postgres wish list
Next
From: Thomas Kellerer
Date:
Subject: Re: postgres wish list