Re: [ADMIN] check_postgres_bloat

2010-06-11 Thread Greg Smith
dx k9 wrote: check_postgres checks for both index and table bloat. It looks like my indexes are ok, this is just picking up on table bloat. I'm not sure what I can do to reclaim the wasted space other than vacuum full & analyze. Maybe a pgdump will do it. CLUSTER will rebuild a new cop

Re: [ADMIN] check_postgres_bloat

2010-06-11 Thread Kenneth Marshall
On Fri, Jun 11, 2010 at 10:50:20AM -0400, dx k9 wrote: > > Hi, > > > > I'm running a the check_postgres.pl --action=bloat on a database and finding > that there is wasted space. > > > > I'm using 95% for the crtical %. If I use 110% I get the same things, but > 115% shows everything is