Hi Michael and Fujii,
Il 01/02/14 17:46, Fujii Masao ha scritto:
> I think that it's OK to add that as TODO item. There might be
> the system that the speed of WAL archiving is slower than
> that of WAL generation, at peak time. The DBA of that system
> might want to monitor the size of archive queue.
I agree that it is an interesting thing to do. The reason I didn't
introduce it in the first place was that I did not want to make too many
changes in this first attempt.
> We can implement this by just counting the files with .ready
> extension in pg_xlog/archive_status directory. Or we can also
> implement that by adding new counter field in pg_stat_archiver
> structure, incrementing it whenever creating .ready file, and
> decrementing it whenever changing .ready to .done.
I would love to give it a shot at the next opportunity.
Thanks,
Gabriele
-- Gabriele Bartolini - 2ndQuadrant ItaliaPostgreSQL Training, Services and Supportgabriele.bartolini@2ndQuadrant.it |
www.2ndQuadrant.it