| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | <lnd(at)hnit(dot)is> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: FW: Postgres: VACUUM |
| Date: | 2004-01-14 22:24:18 |
| Message-ID: | Pine.LNX.4.33.0401141523110.25071-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 14 Jan 2004 lnd(at)hnit(dot)is wrote:
>
> > On heavily used databases (over 100,000 transactions an
> > hour), vacuum is
> > a killer
>
> That's about 27 tx/second - not so many, for some tasks at least.
>
> If VACUUM is rather a killer
> - are any plans from PostgreSQL to deal with that?
Yes, Tom and friends have been tossing back and forth a patch to implement
a sleep between x number of pages being vacuumed to remove the heavy load
vacuum can place on a system. Early testing looks promising, so it's
likely that if enough of us order Tom or somebody a pizza it will get
done. :-) I certainly would like to see it.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith C. Perry | 2004-01-14 22:24:28 | Re: Postgress and MYSQL |
| Previous Message | scott.marlowe | 2004-01-14 22:22:03 | Re: Postgress and MYSQL |