Re: Transaction problem?

Поиск
Список
Период
Сортировка
От Kurt Roeckx
Тема Re: Transaction problem?
Дата
Msg-id 20030415233944.GA26561@ping.be
обсуждение исходный текст
Ответ на Re: Transaction problem?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Are we losing momentum?
Следующее
От: ow
Дата:
Сообщение: Re: Are we losing momentum?