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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: When adding millions of rows at once, getting out of disk space errors
Дата
Msg-id 25716.1234990614@sss.pgh.pa.us
обсуждение исходный текст
Ответ на When adding millions of rows at once, getting out of disk space errors  (Mike Christensen <imaudi@comcast.net>)
Список pgsql-general
Mike Christensen <imaudi@comcast.net> writes:
> I'm doing some perf testing and need huge amounts of data.  So I have a
> program that is adding data to a few tables ranging from 500,000 to 15M
> rows.  The program is just a simply C# program that blasts data into the
> DB, but after about 3M rows or so I get an errror:

> ERROR:  could not extend relation 1663/41130/41177: No space left on device
> HINT:  Check free disk space.

Not to put too fine a point on it, but maybe you need to buy a bigger
disk.

            regards, tom lane

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

Предыдущее
От: Mike Christensen
Дата:
Сообщение: Re: When adding millions of rows at once, getting out of disk space errors
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Appending \o output instead of overwriting the output file