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

On Thu, Feb 19, 2009 at 3:11 AM, Mike Christensen <imaudi@comcast.net> wrote:
> 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..

They're certainly supposed to.  I've had no such problems running out
of space on linux in the past.  I wonder if it's a windows thing.