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