From: me@alternize.com
To: pgsql-performance@postgresql.org
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Date: Mon, 16 Jan 2006 23:48:10 +0100
Message-ID: <070501c61aee$ed450560$6402a8c0@iwing> (raw)
References: <43CC1938.7020807@gmail.com>
<18875.1137451410@sss.pgh.pa.us>
> That does sound like a lack-of-vacuuming problem. If the performance
> goes back where it was after VACUUM FULL, then you can be pretty sure
> of it. Note that autovacuum is not designed to fix this for you: it
> only ever issues regular vacuum not vacuum full.
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?
thanks,
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
Subject: Re: new to postgres (and db management) and performance already a problem :-(
In-Reply-To: <070501c61aee$ed450560$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