Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Date
Msg-id CAFj8pRC+Gcskcgd+ifB8VZT9Z0hk-rX6NZXRAJLM_z8FZHfc+Q@mail.gmail.com
Whole thread Raw
In response to Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system  (Tomas Vondra <tv@fuzzy.cz>)
Responses Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>
>> with the patch:
>> vacuumdb -a    real    6m41.306s
>> idle steady state:  7.86% user, 5.00% system  0.09% iowait  87% idle,
>
> Nice. Another interesting numbers would be device utilization, average
> I/O speed and required space (which should be ~2x the pgstat.stat size
> without the patch).
>

this point is important - with large warehouse with lot of databases
and tables you have move stat file to some ramdisc - without it you
lost lot of IO capacity - and it is very important if you need only
half sized ramdisc

Regards

Pavel



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: sql_drop Event Trigger
Next
From: Dimitri Fontaine
Date:
Subject: Re: sql_drop Event Trigger