Re: Freezing without write I/O
От
Jeff Davis
Тема
Re: Freezing without write I/O
Дата
Msg-id
1378149397.21540.72.camel@jdavis
Ответ на
Re: Freezing without write I/O (Andres Freund)
Список
Дерево обсуждения
Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Bruce Momjian <bruce@momjian.us>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Bruce Momjian <bruce@momjian.us>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Greg Stark <stark@mit.edu>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Greg Stark <stark@mit.edu>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Hannu Krosing <hannu@2ndQuadrant.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Hannu Krosing <hannu@2ndQuadrant.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Avoiding bloat in the presence of a long-running transaction (Re:
Freezing without write I/O) Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Jeff Davis <pgsql@j-davis.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Jeff Davis <pgsql@j-davis.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Peter Eisentraut <peter_e@gmx.net>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Freezing without write I/O Ants Aasma <ants@cybertec.at>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O didier <did447@gmail.com>
Re: Freezing without write I/O didier <did447@gmail.com>
Re: Freezing without write I/O Ants Aasma <ants@cybertec.at>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Ants Aasma <ants@cybertec.at>
Re: Freezing without write I/O Peter Eisentraut <peter_e@gmx.net>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Jeff Janes <jeff.janes@gmail.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Peter Geoghegan <pg@heroku.com>
Re: Freezing without write I/O Andres Freund <andres@2ndquadrant.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Jeff Janes <jeff.janes@gmail.com>
Re: Freezing without write I/O David Fetter <david@fetter.org>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Freezing without write I/O Jeff Janes <jeff.janes@gmail.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
Re: Freezing without write I/O Robert Haas <robertmhaas@gmail.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
Re: Freezing without write I/O Merlin Moncure <mmoncure@gmail.com>
Re: Freezing without write I/O Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Freezing without write I/O Simon Riggs <simon@2ndQuadrant.com>
On Fri, 2013-08-30 at 20:34 +0200, Andres Freund wrote: > I have a quick question: The reason I'd asked about the status of the > patch was that I was thinking about the state of the "forensic freezing" > patch. After a quick look at your proposal, we still need to freeze in > some situations (old & new data on the same page basically), so I'd say > it still makes sense to apply the forensic freezing patch, right? > > Differing Opinions? The Freeze Forensically patch is nice because (if I understand it correctly) it allows us to freeze at the same time as we mark PD_ALL_VISIBLE, which avoids the potential extra page write. But that's not such a big advantage if we don't ordinarily have to write again for freezing, anyway. However, there are still some cases where we'd be able to preserve the forensic information. If nothing else, that might help debug this patch, if necessary. There might also be cases where we can freeze more eagerly to avoid the case where very old (but unfrozen) and very new tuples mix on the same page. Perhaps Robert has some thoughts here, as well. Regards,Jeff Davis
В списке pgsql-hackers по дате отправления