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

Re: Is autovaccum lazy?

From: Brian Modra <epailty(at)googlemail(dot)com>
To: A B <gentosaker(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Is autovaccum lazy?
Date: 2009-12-05 13:38:43
Message-ID: 5a9699850912050538k27aec805gf6a68b725adfa3e8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
2009/12/5 A B <gentosaker(at)gmail(dot)com>:
> 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?

Vacuum full clears up more space, than plain vacuum... however, that
does not mean its "better", in fact, its not advised:
http://wiki.postgresql.org/wiki/VACUUM_FULL#When_.28not.29_to_use_VACUUM_FULL

>
> I might have a similar system I could run these commands on. Any
> advice on other commands to run then to find out more?
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>



-- 
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/

In response to

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2009-12-10 19:07:38
Subject: one or 2 transactions?
Previous:From: A BDate: 2009-12-05 08:36:16
Subject: Is autovaccum lazy?

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