| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Optimization |
| Date: | 2003-07-29 07:21:30 |
| Message-ID: | 3F266DD2.30197.46AAB7A@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 29 Jul 2003 at 8:14, Peter Childs wrote:
> On Tue, 29 Jul 2003, Shridhar Daithankar wrote:
>
> > On 28 Jul 2003 at 12:27, Josh Berkus wrote:
> > > Unless you're running PostgreSQL 7.1 or earlier, you should be VACUUMing every
> > > 10-15 minutes, not every 2-3 hours. Regular VACUUM does not lock your
> > > database. You will also want to increase your FSM_relations so that VACUUM
> > > is more effective/efficient; again, see the articles.
> >
> > There is an auto-vacuum daemon in contrib and if I understand it correctly, it
> > is not getting much of a field testing. How about you guys installing it and
> > trying it?
>
> If there is such a daemon, what is it called? As I can't see it.
> Is it part of gborg?
It is in sources. See contrib module in postgresql CVS, 7.4 beta if you prefer
to wait till announement.
It is called as pgavd..
Bye
Shridhar
--
squatcho, n.: The button at the top of a baseball cap. -- "Sniglets", Rich
Hall & Friends
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2003-07-29 11:56:56 | autovacuum |
| Previous Message | Peter Childs | 2003-07-29 07:14:59 | Re: Optimization |