Re: Displaying accumulated autovacuum cost - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Displaying accumulated autovacuum cost
Date
Msg-id 4E5A106D.9050308@2ndQuadrant.com
Whole thread Raw
In response to Re: Displaying accumulated autovacuum cost  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: Displaying accumulated autovacuum cost
Re: Displaying accumulated autovacuum cost
List pgsql-hackers
Updated patch cleans up two diff mistakes made when backing out the
progress report feature.  The tip-off I screwed up should have been the
absurdly high write rate shown.  The usleep was accidentally deleted, so
it was running without cost limits even applying.  Here's a good one
instead:

LOG:  automatic vacuum of table "pgbench.public.pgbench_accounts": index
scans: 1
     pages: 0 removed, 163935 remain
     tuples: 2000000 removed, 2928356 remain
     buffer usage: 117393 hits, 123351 misses, 102684 dirtied, 2.168
MiB/s write rate
     system usage: CPU 2.54s/6.27u sec elapsed 369.99 sec

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us


Attachment

pgsql-hackers by date:

Previous
From: pasman pasmański
Date:
Subject: Re: spinlocks on HP-UX
Next
From: Dean Rasheed
Date:
Subject: Re: Inputting relative datetimes