Re: Patch: add timing of buffer I/O requests

Поиск
Список
Период
Сортировка
Искать
От
Ants Aasma
Тема
Re: Patch: add timing of buffer I/O requests
Дата
Msg-id
CA+CSw_vVG8vW88tdj9x=pndHs3U35Q1OqDKDVAf0=S93=JVr8A@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Patch: add timing of buffer I/O requests Ants Aasma <ants.aasma@eesti.ee>
Re: Patch: add timing of buffer I/O requests Greg Smith <greg@2ndQuadrant.com>
Re: Patch: add timing of buffer I/O requests Martijn van Oosterhout <kleptog@svana.org>
Re: Patch: add timing of buffer I/O requests "Tomas Vondra" <tv@fuzzy.cz>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Greg Smith <greg@2ndQuadrant.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Greg Stark <stark@mit.edu>
Re: Patch: add timing of buffer I/O requests "Tomas Vondra" <tv@fuzzy.cz>
Re: Patch: add timing of buffer I/O requests Jim Nasby <jim@nasby.net>
Re: Patch: add timing of buffer I/O requests Tomas Vondra <tv@fuzzy.cz>
Re: Patch: add timing of buffer I/O requests Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Ants Aasma <ants.aasma@eesti.ee>
Re: Patch: add timing of buffer I/O requests Tomas Vondra <tv@fuzzy.cz>
Re: Patch: add timing of buffer I/O requests Greg Smith <greg@2ndQuadrant.com>
Re: Patch: add timing of buffer I/O requests Ants Aasma <ants.aasma@eesti.ee>
Re: Patch: add timing of buffer I/O requests Jim Nasby <jim@nasby.net>
Re: Patch: add timing of buffer I/O requests Ants Aasma <ants.aasma@eesti.ee>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Ants Aasma <ants@cybertec.at>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Ants Aasma <ants@cybertec.at>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Peter Eisentraut <peter_e@gmx.net>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Peter Geoghegan <peter@2ndquadrant.com>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Peter Eisentraut <peter_e@gmx.net>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Greg Stark <stark@mit.edu>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Greg Stark <stark@mit.edu>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests "ktm@rice.edu" <ktm@rice.edu>
Re: Patch: add timing of buffer I/O requests Magnus Hagander <magnus@hagander.net>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Greg Smith <greg@2ndQuadrant.com>
Re: Patch: add timing of buffer I/O requests Jim Nasby <jim@nasby.net>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Greg Smith <greg@2ndQuadrant.com>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Peter Geoghegan <peter@2ndquadrant.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Peter Geoghegan <peter@2ndquadrant.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Peter Geoghegan <peter@2ndquadrant.com>
Re: Patch: add timing of buffer I/O requests "ktm@rice.edu" <ktm@rice.edu>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Peter Geoghegan <peter@2ndquadrant.com>
Re: Patch: add timing of buffer I/O requests Greg Stark <stark@mit.edu>
Re: Patch: add timing of buffer I/O requests Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Peter Geoghegan <peter@2ndquadrant.com>
Re: Patch: add timing of buffer I/O requests Peter Geoghegan <peter@2ndquadrant.com>
Re: Patch: add timing of buffer I/O requests Magnus Hagander <magnus@hagander.net>
Re: Patch: add timing of buffer I/O requests Peter Geoghegan <peter@2ndquadrant.com>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Greg Stark <stark@mit.edu>
Re: Patch: add timing of buffer I/O requests Robert Haas <robertmhaas@gmail.com>
Re: Patch: add timing of buffer I/O requests Ants Aasma <ants.aasma@eesti.ee>
Re: Patch: add timing of buffer I/O requests Greg Smith <greg@2ndQuadrant.com>
Re: Patch: add timing of buffer I/O requests Greg Smith <greg@2ndQuadrant.com>
Here's the second version of the I/O timings patch. Changes from the
previous version:

* Rebased against master.
* Added the missing pg_stat_statements upgrade script that I
accidentally left out from the previous version.
* Added a tool to test timing overhead under contrib/pg_test_timing

I hope that having a tool to measure the overhead and check the sanity
of clock sources is enough to answer the worries about the potential
performance hit. We could also check that the clock source is fast
enough on start-up/when the guc is changed, but that seems a bit too
much and leaves open the question about what is fast enough.

About issues with stats file bloat - if it really is a blocker, I can
easily rip out the per-table or even per-database stats fields. The
patch is plenty useful without them. It seemed like a useful tool for
overworked DBAs with limited amount of SSD space available to easily
figure out which tables and indexes would benefit most from fast
storage.

--
Ants Aasma
В списке pgsql-hackers по дате отправления
От: Josh Kupershmidt
Дата:
От: Peter Geoghegan
Дата:
Сообщение: Group commit, revised
FAQ