Re: I/O on select count(*)
От
Tom Lane
Тема
Re: I/O on select count(*)
Дата
Msg-id
21814.1211816217@sss.pgh.pa.us
Ответ на
Re: I/O on select count(*) (Heikki Linnakangas)
Список
Дерево обсуждения
I/O on select count(*) Doug Eck <deck1@yahoo.com>
Re: I/O on select count(*) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: I/O on select count(*) Greg Smith <gsmith@gregsmith.com>
Re: I/O on select count(*) Alvaro Herrera <alvherre@commandprompt.com>
Re: I/O on select count(*) James Mansion <james@mansionfamily.plus.com>
Re: I/O on select count(*) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: I/O on select count(*) Greg Smith <gsmith@gregsmith.com>
Re: I/O on select count(*) "Jan de Visser" <jdevisser@digitalfairway.com>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) Jan de Visser <jdevisser@digitalfairway.com>
Re: I/O on select count(*) Robert Lor <Robert.Lor@Sun.COM>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) Robert Lor <Robert.Lor@Sun.COM>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: I/O on select count(*) Luke Lonergan <llonergan@greenplum.com>
Re: I/O on select count(*) "Joshua D. Drake" <jd@commandprompt.com>
Re: I/O on select count(*) Tino Wildenhain <tino@wildenhain.de>
Re: I/O on select count(*) Gregory Stark <stark@enterprisedb.com>
Re: I/O on select count(*) Matthew Wakeling <matthew@flymine.org>
Re: I/O on select count(*) Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: I/O on select count(*) Greg Smith <gsmith@gregsmith.com>
Re: I/O on select count(*) Alvaro Herrera <alvherre@commandprompt.com>
Re: I/O on select count(*) "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: I/O on select count(*) Alvaro Herrera <alvherre@commandprompt.com>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) Matthew Wakeling <matthew@flymine.org>
Re: I/O on select count(*) Alvaro Herrera <alvherre@commandprompt.com>
Re: I/O on select count(*) Greg Smith <gsmith@gregsmith.com>
Re: I/O on select count(*) Simon Riggs <simon@2ndquadrant.com>
Re: I/O on select count(*) Alvaro Herrera <alvherre@commandprompt.com>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) Jeremy Harris <jgh@wizmail.org>
Re: I/O on select count(*) Greg Smith <gsmith@gregsmith.com>
Re: I/O on select count(*) Decibel! <decibel@decibel.org>
Re: I/O on select count(*) Decibel! <decibel@decibel.org>
Re: I/O on select count(*) "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) Simon Riggs <simon@2ndquadrant.com>
Re: I/O on select count(*) Matthew Wakeling <matthew@flymine.org>
Re: I/O on select count(*) Bruce Momjian <bruce@momjian.us>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) Greg Smith <gsmith@gregsmith.com>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) PFC <lists@peufeu.com>
Re: I/O on select count(*) Alvaro Herrera <alvherre@commandprompt.com>
Re: I/O on select count(*) "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: I/O on select count(*) Matthew Wakeling <matthew@flymine.org>
Re: I/O on select count(*) Tom Lane <tgl@sss.pgh.pa.us>
Re: I/O on select count(*) "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: I/O on select count(*) Matthew Wakeling <matthew@flymine.org>
Re: I/O on select count(*) "Merlin Moncure" <mmoncure@gmail.com>
"Heikki Linnakangas" writes: > Decibel! wrote: >> Also, Simon and Tom had an idea at PGCon: Don't set hint-bits in the >> back-end if the page isn't already dirty. > Or even better: set the hint-bits, but don't dirty the page. Which in fact is what Simon suggested, not the other thing. regards, tom lane
В списке pgsql-performance по дате отправления
