Re: new to postgres (and db management) and performance already a problem :-(

From: <me(at)alternize(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Date: 2006-01-16 22:48:10
Message-ID: 070501c61aee$ed450560$6402a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-01-17 01:08:55 Re: new to postgres (and db management) and performance already a problem :-(
Previous Message Tom Lane 2006-01-16 22:43:30 Re: new to postgres (and db management) and performance already a problem :-(