Re: frustration with database size - Mailing list pgsql-general

From Einar Karttunen
Subject Re: frustration with database size
Date
Msg-id 20020120134627.GA13087@shellak.helsinki.fi
Whole thread Raw
In response to frustration with database size  (Andrew Gould <andrewgould@yahoo.com>)
List pgsql-general
On 20.01.02 05:12 -0800(+0000), Andrew Gould wrote:
> The process above resulted in an **increase** in
> database size from 12GB to 14GB.
>
> I'm both surprised and stumped.  Obviously, there's
> much I'm not understanding about COPY, vacuumdb and
> database size.
>
> Does anyone have any guidance?
>
Which files are taking up the space? Just look inside the
database directory. The files are named by oids. One
suspect is indexes, which may result in space loss.

- Einar Karttunen

pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: frustration with database size
Next
From: Justin Clift
Date:
Subject: LinuxTag 2002 - European Linux Conference, June 6-9