Row Count Mismatch in Postgres Tables

[ChandraSaiKarthik]

Summary
The public.suppliers table actually holds 29 rows, but the table count is shown as 1 rows in the object tree.
This is observed in Postgres Database Tables Only. (MSSQL shows correctly with the same schema and data)

Postgres Database

MSSQL Database

[mikeburgh]

On Postgres you need to run analyze or vacuum periodically to get more updated row count information

[ChandraSaiKarthik]

Perfect, it worked. (but i cant run the vacuum or analyse evevrytime)

There is another method to rely on for table counts:

[mikeburgh]

Thanks, did not know that column was there… I have added support for it if it exists and fallback to the old rowtuples when it does not exist (it's not in some of the pg compatible engines like clickhouse, redshift).

Fixed in 1.17.27