I just ran these commands
So I guess that the vaccuum full command released space that was not
used any more. A week ago I guess the same commands would have
resulted in quite similar numbers. Is there some way of finding out
what the autovaccum have done? I'm having a hard time beliving that
the autovaccuum has done it's job properly since there were so much
"wasted" space, or did it just not find it worth the effort to release
the unused space?
Any thoughts about this?
I might have a similar system I could run these commands on. Any
advice on other commands to run then to find out more?
pgsql-novice by date
|Next:||From: Brian Modra||Date: 2009-12-05 13:38:43|
|Subject: Re: Is autovaccum lazy?|
|Previous:||From: Lonni J Friedman||Date: 2009-12-03 23:22:52|
|Subject: Re: auto-increment integer field for each row|