Re: frustration with database size <long>

From: Einar Karttunen <ekarttun(at)cs(dot)helsinki(dot)fi>
To: Andrew Gould <andrewgould(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: frustration with database size <long>
Date: 2002-01-20 13:46:27
Message-ID: 20020120134627.GA13087@shellak.helsinki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jeff fitzmyers 2002-01-20 14:56:42 Re: Long running queries and timeouts
Previous Message Andrew Gould 2002-01-20 13:12:04 frustration with database size <long>