Re: Load distributed checkpoint
От
Inaam Rana
Тема
Re: Load distributed checkpoint
Дата
Msg-id
833c669b0612100649k5cba78f7w4b3dd15203367851@mail.gmail.com
Ответ на
Re: Load distributed checkpoint (Kevin Grittner)
Список
Дерево обсуждения
Load distributed checkpoint ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Load distributed checkpoint "Jim C. Nasby" <jim@nasby.net>
Re: Load distributed checkpoint "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Load distributed checkpoint Tom Lane <tgl@sss.pgh.pa.us>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint "Simon Riggs" <simon@2ndquadrant.com>
Re: Load distributed checkpoint Martijn van Oosterhout <kleptog@svana.org>
Re: Load distributed checkpoint "Simon Riggs" <simon@2ndquadrant.com>
Re: Load distributed checkpoint "Jim C. Nasby" <jim@nasby.net>
Re: Load distributed checkpoint ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint "Jim C. Nasby" <jim@nasby.net>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint Tom Lane <tgl@sss.pgh.pa.us>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint Heikki Linnakangas <heikki@enterprisedb.com>
Re: Load distributed checkpoint "Jim C. Nasby" <jim@nasby.net>
Re: Load distributed checkpoint Tom Lane <tgl@sss.pgh.pa.us>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint "Jim C. Nasby" <jim@nasby.net>
Re: Load distributed checkpoint "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
Re: Load distributed checkpoint ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Load distributed checkpoint Gregory Stark <stark@enterprisedb.com>
Re: Load distributed checkpoint Bruce Momjian <bruce@momjian.us>
Re: Load distributed checkpoint Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: Load distributed checkpoint Gregory Stark <stark@enterprisedb.com>
Re: Load distributed checkpoint Tom Lane <tgl@sss.pgh.pa.us>
Re: Load distributed checkpoint "Jim C. Nasby" <jim@nasby.net>
Re: Load distributed checkpoint "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Load distributed checkpoint "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Load distributed checkpoint Brad Nicholson <bnichols@ca.afilias.info>
Re: Load distributed checkpoint "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Load distributed checkpoint ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Load distributed checkpoint Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: Load distributed checkpoint "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Load distributed checkpoint "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
Re: Load distributed checkpoint "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Load distributed checkpoint "Inaam Rana" <inaamrana@gmail.com>
Re: Load distributed checkpoint ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Load distributed checkpoint Greg Smith <gsmith@gregsmith.com>
Unless PostgreSQL gets much closer to the hardware than the community
consensus seems to support, I don't understand what you could do in the
checkpoint phase that would improve on that. (That, of course, doesn't
mean I'm not missing something, just that the arguments made so far
haven't shown me that the suggested changes would do anything but move
the problem around a little bit.)
If we can try out things like O_SYNC and/or O_DIRECT that will give us exact information about dirty pages that need be written to the disk at any given point in time. We can then use this information to design light weight checkpoints.
В списке pgsql-hackers по дате отправления