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: dbbf25900912050036s211d8c90x70d20ce915c8f007@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello.
I just ran these commands

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

and got

315250448
----
90669060

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?

Responses

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-2014 The PostgreSQL Global Development Group