Brad Nicholson napsal(a):
>> I just put together a view, which helps us in indentifying which
>> database tables are suffering from space bloat, ie. they take up much
> Are you sure you haven't reinvented the wheel? Have you checked out
> contrib/pgstattuple ?
Well, I wasn't aware of it, so I guess I did reinvent the wheel. I
Googled for a solution to this problem, but Googled poorly I suppose.
On the other hand, pgstattuple might be a bit difficult to use for
not-so-experienced users in answering the question "Which table should I
shrink?", as you have to first install it from contrib and then come up
with a select to pick the "worst" relations.
Anyway, if someone finds this view useful, good. If not, ignore it.
Bye.
--
Michal Táborský
IT operations chief
Internet Mall, a.s.
<http://www.MALL.cz>