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
|
| Список | pgsql-hackers |
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 по дате отправления: