Request a Demo
Home   >   mailing lists

Re: db size and VACUUM ANALYZE - Mailing list pgsql-general

From Marcin Krol
Subject Re: db size and VACUUM ANALYZE
Date
Msg-id 4B759328.6050306@gmail.com
Whole thread Raw
In response to Re: db size and VACUUM ANALYZE  (Amitabh Kant <amitabhkant@gmail.com>)
Responses Re: db size and VACUUM ANALYZE
Re: db size and VACUUM ANALYZE
List pgsql-general
Tree view 
Amitabh Kant wrote:
> You need to do VACUUM FULL ANALYZE to claim the disk space, but this
> creates a exclusive lock on the tables.
>
> See http://www.postgresql.org/docs/8.3/static/sql-vacuum.html

Aha!

OK but why did the performance degrade so much? The same reason -- lack
of autovacuuming/vacuum full?

Regards,
mk

pgsql-general by date:

Previous
From: Amitabh Kant
Date:
Subject: Re: db size and VACUUM ANALYZE
Next
From: Joao Ferreira gmail
Date:
Subject: Re: db size and VACUUM ANALYZE