Re: Transaction problem? - Mailing list pgsql-hackers

From Kurt Roeckx
Subject Re: Transaction problem?
Date
Msg-id 20030415233944.GA26561@ping.be
Whole thread Raw
In response to Re: Transaction problem?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Apr 15, 2003 at 07:23:32PM -0400, Tom Lane wrote:
> Kurt Roeckx <Q@ping.be> writes:
> > I have a database where I deleted all records from all tables.  I
> > run a vacuum full and am left with about 1 GB of data.
> 
> Indexes maybe?  If you don't identify *where* the space is, we can't
> say much.

I'm exactly sure what's store in that file, or how I have to find
that out.

The biggest file is base/25168/4887238 which is about 750 MB.
I believe that is the biggest table.

How can I find out what is in it?


Kurt



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Are we losing momentum?
Next
From: ow
Date:
Subject: Re: Are we losing momentum?