Thom Brown t...@linux.com writes:
I was wondering whether anyone has any insight with regards to
measuring and reporting the overhead of maintaining indexes on
relations. If an UPDATE is issued to a table with, say, 6 indexes, it
would be useful to determine how much time is spent updating
On 7 December 2013 19:41, Tom Lane t...@sss.pgh.pa.us wrote:
Thom Brown t...@linux.com writes:
I was wondering whether anyone has any insight with regards to
measuring and reporting the overhead of maintaining indexes on
relations. If an UPDATE is issued to a table with, say, 6 indexes, it
Thom Brown t...@linux.com writes:
Perhaps I may have misunderstood, or not explained my question with
enough detail, but you appear to be including activity that would, in
all likelihood, occur after the DML has returned confirmation to the
user that it has completed; in particular, VACUUM.
On 7 December 2013 20:44, Tom Lane t...@sss.pgh.pa.us wrote:
Thom Brown t...@linux.com writes:
So in essence, I'd only be looking for a breakdown of anything that
adds to the duration of the DML statement. However, it sounds like
even that isn't straightforward from what you've written.
I