Re: db size and VACUUM ANALYZE

From: Marcin Krol <mrkafk(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: db size and VACUUM ANALYZE
Date: 2010-02-12 17:43:04
Message-ID: 4B759328.6050306@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joao Ferreira gmail 2010-02-12 17:51:40 Re: db size and VACUUM ANALYZE
Previous Message Amitabh Kant 2010-02-12 17:18:13 Re: db size and VACUUM ANALYZE