""David F. Skoll"" <dfs@roaringpenguin.com> wrote in message
news:Pine.LNX.4.50.0301031015260.2549-100000@shishi.roaringpenguin.com...
> > It's possible your suffering index bloat as well and you might need to
> > do some regular reindexing,
>
> Again, this sounds ugly. How do you determine this? How do you get your
> database to be reindexed as often as needed, but not too often?
Sound more ugly considering that some times the reindex is not possible
if the server is stressed ( the reindex hang ) for my experience
instead of do a reindex is better delete the indexes and recreate them.
With the following query you can obtain the size of each table or index:
SELECT relname, relpages * 8 AS Mb, reltuples
FROM pg_class
ORDER BY relpages DESC
LIMIT 10;
If you use the 7.3 I think you should multiply for 11.
Ciao
Gaetano.
