From: me@alternize.com
To: Michael Riess <mlriess@gmx.de>
To: pgsql-performance@postgresql.org
Subject: Re: 15,000 tables
Date: Thu, 1 Dec 2005 18:07:37 +0100
Message-ID: <06f401c5f699$bbae2af0$0201a8c0@iwing> (raw)
References: <dmmujf$2rgd$1@news.hub.org>
<c2d9e70e0512010742p5e5fb61dx84dfb8e332c05352@mail.gmail.com>
<dmn6tm$1n9n$1@news.hub.org>
hi michael
>> Have you ANALYZEd your database? VACUUMing?
>
> Of course ... before 8.1 we routinely did a vacuum full analyze each
> night. As of 8.1 we use autovacuum.
what i noticed is autovacuum not working properly as it should. i had 8.1
running with autovacuum for just 2 days or so and got warnings in pgadmin
that my tables would need an vacuum. i've posted this behaviour some weeks
ago to the novice list requesting more infos on how to "tweak" autovacuum
properly - unfortunately without any respones. thats when i switched the
nightly analyze job back on - everything runs smooth since then.
maybe it helps in your case as well?
cheers,
thomas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: me@alternize.com, mlriess@gmx.de
Subject: Re: 15,000 tables
In-Reply-To: <06f401c5f699$bbae2af0$0201a8c0@iwing>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox