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