On 1/6/20 1:36 μ.μ., Julien Rouhaud wrote:
On Mon, Jun 1, 2020 at 12:02 PM Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> wrote: Because read only transaction usually don't consume an xid. So yes pg_stat_database gives a more reasonable approximation of the real number of transactions happening on the server.
Thank you, so what would be the official way to monitor txid consumption (from a MVCC / Freezing admin POV)?
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
