Re: Idea for getting rid of VACUUM FREEZE on cold pages

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
Re: Idea for getting rid of VACUUM FREEZE on cold pages
Дата
Msg-id
1276035506.12489.4314.camel@ebony
Ответ на
Список
Дерево обсуждения
Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Jan Wieck <JanWieck@Yahoo.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Jan Wieck <JanWieck@Yahoo.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Jesper Krogh <jesper@krogh.cc>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Joe Conway <mail@joeconway.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Russell Smith <mr-russ@pws.com.au>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Alvaro Herrera <alvherre@commandprompt.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Alvaro Herrera <alvherre@commandprompt.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Bruce Momjian <bruce@momjian.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Jan Wieck <JanWieck@Yahoo.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Simon Riggs <simon@2ndQuadrant.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Simon Riggs <simon@2ndQuadrant.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Simon Riggs <simon@2ndQuadrant.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Alvaro Herrera <alvherre@commandprompt.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Simon Riggs <simon@2ndQuadrant.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Jan Wieck <JanWieck@Yahoo.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages marcin mank <marcin.mank@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Stephen Frost <sfrost@snowman.net>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Greg Stark <gsstark@mit.edu>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Stephen Frost <sfrost@snowman.net>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Jan Wieck <JanWieck@Yahoo.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Greg Smith <greg@2ndquadrant.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Bruce Momjian <bruce@momjian.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Bruce Momjian <bruce@momjian.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Bruce Momjian <bruce@momjian.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Alvaro Herrera <alvherre@commandprompt.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Bruce Momjian <bruce@momjian.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Greg Stark <gsstark@mit.edu>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Greg Stark <gsstark@mit.edu>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Bruce Momjian <bruce@momjian.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Jan Wieck <JanWieck@Yahoo.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Robert Haas <robertmhaas@gmail.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Jesper Krogh <jesper@krogh.cc>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Tom Lane <tgl@sss.pgh.pa.us>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Josh Berkus <josh@agliodbs.com>
Re: Idea for getting rid of VACUUM FREEZE on cold pages Florian Pflug <fgp@phlo.org>
On Tue, 2010-06-08 at 18:03 -0400, Robert Haas wrote:
> OK, yes, I see what you're getting at now.  There are two possible
> ways to do freeze the tuples and keep the xmin: we can either rely on
> the PD_ALL_VISIBLE page-level bit (as I previously proposed) or we can
> additionally have a HEAP_XMIN_FROZEN bit as you propose here.  I am
> not sure which way is better.

Doing it at tuple level is more flexible and allows more aggressive
freezing. It also works better with existing tuple visibility code.

-- Simon Riggs           www.2ndQuadrant.com


В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Josh Berkus
Дата:
FAQ