Re: frustration with database size <long>

Einar Karttunen <ekarttun@cs.helsinki.fi>

From: Einar Karttunen <ekarttun@cs.helsinki.fi>
To: Andrew Gould <andrewgould@yahoo.com>
Cc: pgsql-general@postgresql.org
Date: 2002-01-20T13:46:27Z
Lists: 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