Re: autovacuum not freeing up unused space on 8.3.0

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Stuart Brooks" <stuartb(at)cat(dot)co(dot)za>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: autovacuum not freeing up unused space on 8.3.0
Date: 2008-02-26 12:05:15
Message-ID: 87skzf2a9w.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Stuart Brooks" <stuartb(at)cat(dot)co(dot)za> writes:

> It'll take a few minutes but I'll try and get the information to you. A summary
> is:
>
> Process 1:
> - writing 50 rows/second, 1 row/transaction.
> - every so often delete 100 rows
>
> Process 2:
> - running ANALYZE VERBOSE and pg_total_relation_size every second

You'll probably have to vacuum pg_statistics as well then.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2008-02-26 12:08:53 multi-threaded pgloader needs your tests
Previous Message Richard Huxton 2008-02-26 12:03:53 Re: Query meltdown: caching results