Subject: Re: pg_stat_database.xact_commit + pg_stat_database.xact_rollback as
 a reliable metric for xid consumption ?
To: pgsql-admin@lists.postgresql.org
References: <51fa222b-374e-39da-eb8c-66d667426bae@matrix.gatewaynet.com>
 <CAOBaU_Zc5o=pKopyh=U02xw_FPN_ZWBhqe=-hSTPC-n7JF=X2g@mail.gmail.com>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <36dd7ae2-7c6f-86af-430b-dd9a0f7774b3@matrix.gatewaynet.com>
Date: Mon, 1 Jun 2020 13:48:33 +0300
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:60.0) Gecko/20100101
 Thunderbird/60.3.2
MIME-Version: 1.0
In-Reply-To: 
 <CAOBaU_Zc5o=pKopyh=U02xw_FPN_ZWBhqe=-hSTPC-n7JF=X2g@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

On 1/6/20 1:36 μ.μ., Julien Rouhaud wrote:
> On Mon, Jun 1, 2020 at 12:02 PM Achilleas Mantzios
> <achill@matrix.gatewaynet.com> 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