Re: pg_autovacuum vacuum cost variables patch - Mailing list pgsql-patches

From Tom Lane
Subject Re: pg_autovacuum vacuum cost variables patch
Date
Msg-id 10053.1098806814@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_autovacuum vacuum cost variables patch  ("Michael Paesold" <mpaesold@gmx.at>)
List pgsql-patches
"Michael Paesold" <mpaesold@gmx.at> writes:
> And it seems it affects analyze much more than vacuum, at least if there is
> *nothing* to vacuum... (2 seconds -> 8 seconds)

Fixed.  The original coding was charging a page fetch cost for each row
on each page that analyze looked at :-(

            regards, tom lane

pgsql-patches by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: pg_autovacuum vacuum cost variables patch
Next
From: Bruce Momjian
Date:
Subject: Re: pg_ctl -D canonicalization