Skip site navigation (1) Skip section navigation (2)

Is autovaccum lazy?

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Is autovaccum lazy?
Date: 2009-12-05 08:36:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I just ran these commands

select pg_database_size('cdb');
vacuum full;
select pg_database_size('cdb');

and got


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 ModraDate: 2009-12-05 13:38:43
Subject: Re: Is autovaccum lazy?
Previous:From: Lonni J FriedmanDate: 2009-12-03 23:22:52
Subject: Re: auto-increment integer field for each row

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group