Re: Restoring database disk space requirements??? - Mailing list pgsql-general

From Gordan Bobic
Subject Re: Restoring database disk space requirements???
Date
Msg-id 001401c0f807$cb84a020$800010ac@localdomain
Whole thread Raw
In response to Re: Insert and limit  ("Matteo Centenaro" <gente_che_mixa@hotmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.1.2 query now uses hash-join instead of nested loop
Next
From: Tom Lane
Date:
Subject: Re: Apache with PHP and PGSQL crashing ...