From: me@alternize.com
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Date: Tue, 17 Jan 2006 02:29:43 +0100
Message-ID: <071801c61b05$7ea50c10$6402a8c0@iwing> (raw)
References: <43CC1938.7020807@gmail.com>
<18875.1137451410@sss.pgh.pa.us>
<070501c61aee$ed450560$6402a8c0@iwing>
<22960.1137460135@sss.pgh.pa.us>
>> in our db system (for a website), i notice performance boosts after a
>> vacuum
>> full. but then, a VACUUM FULL takes 50min+ during which the db is not
>> really
>> accessible to web-users. is there another way to perform maintenance
>> tasks
>> AND leaving the db fully operable and accessible?
>
> You're not doing regular vacuums often enough.
well, shouldn't autovacuum take care of "regular" vacuums? in addition to
autovacuum, tables with data changes are vacuumed and reindexed once a day -
still performance seems to degrade slowly until a vacuum full is
initiated... could an additional daily vacuum over the entire db (even on
tables that only get data added, never changed or removed) help?
- 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, tgl@sss.pgh.pa.us
Subject: Re: new to postgres (and db management) and performance already a problem :-(
In-Reply-To: <071801c61b05$7ea50c10$6402a8c0@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