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

Поиск
Список
Период
Сортировка
От Mike Christensen
Тема Re: When adding millions of rows at once, getting out of disk space errors
Дата
Msg-id 499D3066.10008@comcast.net
обсуждение исходный текст
Ответ на Re: When adding millions of rows at once, getting out of disk space errors  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Ответы Re: When adding millions of rows at once, getting out of disk space errors  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: postgres wish list
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: postgres wish list