pg_stat_wal: tracking the compression effect
| От | Ken Kato |
|---|---|
| Тема | pg_stat_wal: tracking the compression effect |
| Дата | |
| Msg-id | 0489c74a83dbd54ed33feb6690d7ca4f@oss.nttdata.com обсуждение |
| Ответы |
Re: pg_stat_wal: tracking the compression effect
Re: pg_stat_wal: tracking the compression effect |
| Список | pgsql-hackers |
Hi hackers,
We can specify compression method (for example, lz4, zstd), but it is
hard to know the effect of compression depending on the method. There is
already a way to know the compression effect using pg_waldump. However,
having these statistics in the view makes it more accessible. I am
proposing to add statistics, which keeps track of compression effect in
pg_stat_ wal view.
The design I am thinking is below:
compression_saved | compression_times
------------------+-------------------
38741 | 6
Accumulating the values, which indicates how much space is saved by each
compression (size before compression - size after compression), and keep
track of how many times compression has happened. So that one can know
how much space is saved on average.
What do you think?
Regards,
--
Ken Kato
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION
В списке pgsql-hackers по дате отправления: