User Activity

  • Posted a comment on discussion General Discussion on pg_statsinfo

    Hi, We are running pg_statsinfo with default settings at the moment. Our 50 postgres databases are producing up to 15GB pg_statsinfo data per day. We are looking to reduce this volumina. Idea is to set "pg_statsinfo.snapshot_interval = 12h". Questions: a) Any other ideas? b) Will this setting still generate 5s session states? Cheers, Markus

  • Posted a comment on discussion General Discussion on pg_statsinfo

    hi, we have several postgres clusters running on the same host. we added cluster_names and dns aliases to every cluster for better differentiation and handling. we only see physical hostnames + ports in the pg_reporter overview at the moment, e.g. tstm49254:5432 tstm49251:5433 tstm49252:5432 tstm49251:5432 tstm49255:5432 would it be possible to change the physical hostname to it's appropriate dns alias, e.g. pg_clu1:5432 pg_clu5:5433 pg_clu2:5432 pg_clu3:5432 pg_clu4:5432 thanks, markus

View All

Personal Data

Username:
mzwettler
Joined:
2014-07-08 10:31:01

Projects

  • No projects to display.

Personal Tools