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

Поиск
Список
Период
Сортировка
От Mark Roberts
Тема Re: When adding millions of rows at once, getting out of disk space errors
Дата
Msg-id 1234990951.11148.324.camel@localhost
обсуждение исходный текст
Ответ на Re: When adding millions of rows at once, getting out of disk space errors  (Mike Christensen <imaudi@comcast.net>)
Список pgsql-general
Дерево обсуждения 
On Wed, 2009-02-18 at 12:55 -0800, Mike Christensen wrote:
> I have well over 50 gigs free on that drive..  I doubt it.

Are you sure the pg data directory is on the drive you think it is?  Are
you doing alot of deletes or are you merely inserting?  Are you doing
any sorting and therefore running out of temp space in your tmp
partition [supposition, I've run into something like this before, but
not specifically with Postgres].

-Mark

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

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