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

From Tom Lane
Subject Re: Restoring database disk space requirements???
Date
Msg-id 1843.992876544@sss.pgh.pa.us
Whole thread Raw
In response to Restoring database disk space requirements???  ("Gordan Bobic" <gordan@freeuk.com>)
List pgsql-general
"Gordan Bobic" <gordan@freeuk.com> writes:
> 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.html

> 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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Tim Knowles"
Date:
Subject: 7.1.2 query now uses hash-join instead of nested loop
Next
From: "Richard Huxton"
Date:
Subject: Re: primary/secondary index, difference