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

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Igor Katson
Дата:
Сообщение: Accessing array elements in a FOR PL/pgsql loop
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Accessing array elements in a FOR PL/pgsql loop