Re: Autovacuum in the backend

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum in the backend
Date: 2005-06-17 02:12:06
Message-ID: d8tblj$15mi$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>
> Yeah --- a libpq-based solution is not what I think of as integrated at
> all, because it cannot do anything that couldn't be done by the existing
> external autovacuum process. About all you can buy there is having the
> postmaster spawn the autovacuum process, which is slightly more
> convenient to use but doesn't buy any real new functionality.
>

One reason of not using lib-pq is that this one has to wait for the
completion of each vacuum (we don't has async execution in libpq right?),
but by signaling does not.

But by signaling, we have to detect that if the forked backend successfully
done its job. I am not sure how to easily incorporate this into current
signaling framework.

Regards,
Qingqing

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-06-17 02:15:37 Re: Autovacuum in the backend
Previous Message Tim Allen 2005-06-17 01:04:33 Re: Autovacuum in the backend

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-06-17 02:15:37 Re: Autovacuum in the backend
Previous Message Bruce Momjian 2005-06-17 01:53:45 Re: [PATCHES] Escape handling in strings