From: Tom Lane <tgl@sss.pgh.pa.us>
To: me@alternize.com
Cc: pgsql-performance@postgresql.org
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Date: Mon, 16 Jan 2006 20:08:55 -0500
Message-ID: <22960.1137460135@sss.pgh.pa.us> (raw)
In-Reply-To: <070501c61aee$ed450560$6402a8c0@iwing>
References: <43CC1938.7020807@gmail.com>
<18875.1137451410@sss.pgh.pa.us>
<070501c61aee$ed450560$6402a8c0@iwing>
<me@alternize.com> writes:
> 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.
regards, tom lane
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: tgl@sss.pgh.pa.us, me@alternize.com
Subject: Re: new to postgres (and db management) and performance already a problem :-(
In-Reply-To: <22960.1137460135@sss.pgh.pa.us>
* 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