Postgres Pro
Downloads
Home   >   mailing lists

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

From
Subject Re: new to postgres (and db management) and performance already a problem :-(
Date
Msg-id 070501c61aee$ed450560$6402a8c0@iwing
Whole thread Raw
In response to new to postgres (and db management) and performance already a problem :-(  (Antoine <melser.anton@gmail.com>)
Responses Re: new to postgres (and db management) and performance already a problem :-(
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Next
From: Tom Lane
Date:
Subject: Re: new to postgres (and db management) and performance already a problem :-(