Re: Transaction problem?

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Kurt Roeckx <Q(at)ping(dot)be>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Transaction problem?
Date: 2003-04-16 09:13:00
Message-ID: 1050484380.2315.17.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kurt Roeckx kirjutas K, 16.04.2003 kell 01:36:
> I'm not exactly sure what the problem is, or how it happened.
>
> 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.

Probably indexes.

Delete of all data is slow. If you don't need referetial integrity
maintained then TRUNCATE is much faster. Doing REINDEX after that will
clear out indexes if TRUNCATE does not do it ?

------------------
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2003-04-16 09:16:54 Re: Are we losing momentum?
Previous Message Shridhar Daithankar 2003-04-16 07:55:14 Re: Are we losing momentum?