Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com> writes:
> I observe huge files (200Mb-1GB) in the database base dir which belong
> to pg_toast_<OID>_index relations.
Not too surprising...
> I tried to vacuum full the corresponding user table, reindex this
> table or even drop the indexes to no avail.
REINDEX should have worked; please define "to no avail".
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: A.Bhuvaneswaran||Date: 2003-09-18 04:52:15|
|Subject: Re: how to find multi-byte is enabled or not for 7.2.3|
|Previous:||From: Josh Berkus||Date: 2003-09-17 22:38:33|
|Subject: Re: How to force an Index ?|