Обсуждение: pg_autovacuum update

This patch updates pg_autovacuum in several ways:
* A few bug fixes
* fixes solaris compile and crash issue
* decouple vacuum analyze and analyze thresholds
* detach from tty (dameonize)
* improved logging layout
* more conservative default configuration
* improved, expanded and updated README

please apply and 1st convenience, or before code freeze which ever comes
first :-)

At this point I think I have brought pg_autovacuum and its client side
design as far as I think it should go.  It works, keeping file sizes in
check, helps performance and give the administrator a fair amount
flexibility in configuring it.

Next up is to do the FSM based design that is integrated into the back
end.

Matthew

p.s. Thanks to Christopher Browne for his help.

Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Matthew T. O'Connor wrote:
> This patch updates pg_autovacuum in several ways:
> * A few bug fixes
> * fixes solaris compile and crash issue
> * decouple vacuum analyze and analyze thresholds
> * detach from tty (dameonize)
> * improved logging layout
> * more conservative default configuration
> * improved, expanded and updated README
>
> please apply and 1st convenience, or before code freeze which ever comes
> first :-)
>
> At this point I think I have brought pg_autovacuum and its client side
> design as far as I think it should go.  It works, keeping file sizes in
> check, helps performance and give the administrator a fair amount
> flexibility in configuring it.
>
> Next up is to do the FSM based design that is integrated into the back
> end.
>
> Matthew
>
> p.s. Thanks to Christopher Browne for his help.

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Patch applied.  Thanks.

---------------------------------------------------------------------------


Matthew T. O'Connor wrote:
> This patch updates pg_autovacuum in several ways:
> * A few bug fixes
> * fixes solaris compile and crash issue
> * decouple vacuum analyze and analyze thresholds
> * detach from tty (dameonize)
> * improved logging layout
> * more conservative default configuration
> * improved, expanded and updated README
>
> please apply and 1st convenience, or before code freeze which ever comes
> first :-)
>
> At this point I think I have brought pg_autovacuum and its client side
> design as far as I think it should go.  It works, keeping file sizes in
> check, helps performance and give the administrator a fair amount
> flexibility in configuring it.
>
> Next up is to do the FSM based design that is integrated into the back
> end.
>
> Matthew
>
> p.s. Thanks to Christopher Browne for his help.

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073