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

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 ;)
>
>