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

From: Tom Lane
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Date: ,
Msg-id: 22960.1137460135@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: new to postgres (and db management) and performance already a problem :-(  (<>)
Responses: Re: new to postgres (and db management) and performance  (Markus Schaber)
List: pgsql-performance


<> 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


pgsql-performance by date:

From: Christopher Browne
Date:
Subject: Re: new to postgres (and db management) and performance already a problem :-(
From:
Date:
Subject: Re: new to postgres (and db management) and performance already a problem :-(