Re: Eager page freeze criteria clarification
От
Peter Geoghegan
Тема
Re: Eager page freeze criteria clarification
Дата
Msg-id
CAH2-Wzm-bk+ywCvkNYENpBhW45+s8QDPeUukS3epEYb8EUe46A@mail.gmail.com
Ответ на
Re: Eager page freeze criteria clarification (Melanie Plageman)
Список
Дерево обсуждения
Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Joe Conway <mail@joeconway.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Joe Conway <mail@joeconway.com>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Andres Freund <andres@anarazel.de>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Robert Haas <robertmhaas@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Melanie Plageman <melanieplageman@gmail.com>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
Re: Eager page freeze criteria clarification Peter Geoghegan <pg@bowt.ie>
On Wed, Sep 27, 2023 at 11:36 AM Melanie Plageman wrote: > One big sticking point for me (brought up elsewhere in this thread, but, > AFAICT never resolved) is that it seems like the fact that we mark pages > all-visible even when not freezing them means that no matter what > heuristic we use, we won't have the opportunity to freeze the pages we > most want to freeze. I think of it as being a bit like an absorbing state from a Markov chain. It's a perfect recipe for weird path dependent behavior, which seems to make your task just about impossible. It literally makes vacuuming more frequently lead to less useful work being performed! It does so *reliably*, in the simplest of cases. Ideally, you'd be designing an algorithm for a system where we could expect to get approximately the desired outcome whenever we have approximately the right idea. A system where mistakes tend to "cancel each other out" over time. As long as you have "set all-visible but don't freeze" behavior as your starting point, then ISTM that your algorithm almost has to make no mistakes at all to really improve on what we have right now. As things stand, when your algorithm decides to not freeze (for pages that are still set all-visible in the VM), you really can't afford to be wrong. (I think that you get this already, but it's a point worth emphasizing.) -- Peter Geoghegan
В списке pgsql-hackers по дате отправления