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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: me(at)alternize(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Date: 2006-01-17 01:08:55
Message-ID: 22960.1137460135@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<me(at)alternize(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message me 2006-01-17 01:29:43 Re: new to postgres (and db management) and performance already a problem :-(
Previous Message me 2006-01-16 22:48:10 Re: new to postgres (and db management) and performance already a problem :-(