Hi Sujith
Did you set the vacuum parameter on this table automatically?
Thanks & Best Wishes,
Ashok
---------------------------------------------------------------------------------------------------------------------
Ashokkumar Mani (OCP12c/11g/10g/9i, AWS SAA, M103)
UAE: Faud Al sajwani building , clock Tower , Musallah, Sharjah
M: +971 54 723 0075 | A.M. +971 50 217 9910
W: http://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@xxxxxxxxx
On Mon, Aug 17, 2020 at 12:25 PM Sujith Kumar.S <sujiplr@xxxxxxxxx> wrote:
Hi Team,After the postgresql server restart, the details on the pg_stat_all_tables are showing as zero. Does that mean the stats data also gets reset after the server restart ? How can we prevent this from happening?Regards,Sujith Kumar.S