Re: Transaction problem?

From: Kurt Roeckx <Q(at)ping(dot)be>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Transaction problem?
Date: 2003-04-15 23:39:44
Message-ID: 20030415233944.GA26561@ping.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Apr 15, 2003 at 07:23:32PM -0400, Tom Lane wrote:
> Kurt Roeckx <Q(at)ping(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2003-04-15 23:47:08 Re: Upgrade to Red Hat Linux 9 broke PostgreSQL
Previous Message Wei Weng 2003-04-15 23:29:35 Re: [HACKERS] More thoughts about FE/BE protocol