[GENERAL] tuple statistics update - Mailing list pgsql-general

From Tom DalPozzo
Subject [GENERAL] tuple statistics update
Date
Msg-id CAK77FCRo9VRhJLWR0WGJWaH5K2Ymik1W=HG5ZX7DLEXycRhyHQ@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] tuple statistics update  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: [GENERAL] tuple statistics update  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi, I'm using libpq to insert tuples in my table and keep looking at statistics through psql instead.
I noticed that sometimes n_tuple_ins is not updated even after 1 min that my transaction committed. 
My libpq connection is kept alive. If I close the connection then the stats get updated.
I know that stats are not instantaneous, but I thought that after a while that a transaction is committed it would be updated.
Regards
Pupillo




pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Clone PostgreSQL schema
Next
From: Luciano Mittmann
Date:
Subject: [GENERAL] streaming replication and archive_status