Re: vacuum_cost_page_miss default value and modern hardware
Peter Geoghegan <pg@bowt.ie>
From: Peter Geoghegan <pg@bowt.ie>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-01-22T01:12:01Z
Lists: pgsql-hackers
On Thu, Jan 14, 2021 at 8:34 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote: > +1 for this change. Lowering to 2 also looks good to me. I'm going to go ahead with committing my patch to lower the default next week. If anybody has any objections to that plan, please speak up. It doesn't really need to be said again, but just to be clear: I share the concerns held by Magnus and Robert. It's certainly true that this change alone is no fix for the general problem I described. At the same time I believe that the patch makes incremental progress in the right direction, without much risk. -- Peter Geoghegan
Commits
-
Reduce the default value of vacuum_cost_page_miss.
- e19594c5c059 14.0 landed
-
Cost based vacuum delay feature.
- f425b605f4e9 8.0.0 cited