From: | Ants Aasma <ants(dot)aasma(at)eesti(dot)ee> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Patch: add timing of buffer I/O requests |
Date: | 2012-01-15 22:14:45 |
Message-ID: | CA+CSw_vVG8vW88tdj9x=pndHs3U35Q1OqDKDVAf0=S93=JVr8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
Attachment | Content-Type | Size |
---|---|---|
io-stats.v2.patch | text/x-patch | 64.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2012-01-15 22:42:11 | Group commit, revised |
Previous Message | Josh Kupershmidt | 2012-01-15 22:05:17 | Re: Dry-run mode for pg_archivecleanup |