Re: Restoring database disk space requirements???

Поиск
Список
Период
Сортировка
От Gordan Bobic
Тема Re: Restoring database disk space requirements???
Дата
Msg-id 001401c0f807$cb84a020$800010ac@localdomain
обсуждение исходный текст
Ответ на Re: Insert and limit  ("Matteo Centenaro" <gente_che_mixa@hotmail.com>)
Список pgsql-general
> > Can somebody please explain to me why is it that 20 Gb of disk
space
> > is required to restore 5 GB of data?
>
> You may wish to apply the patch at
>
http://www.ca.postgresql.org/mhonarc/pgsql-patches/2001-06/msg00061.ht
ml

Ah, excellent. I will try that as soon as my current restore attempt
finishes/breaks.

> > What is going on? I have had this same problem with v7.0, and now
with
> > v7.1.
>
> Rather hard to believe, since there was no WAL in 7.0.

Sorry, I meant in upgrading from 7.0 to 7.1.

Thanks.

Gordan



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.1.2 query now uses hash-join instead of nested loop
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Apache with PHP and PGSQL crashing ...