Re: pg_stat_all_tables not updated when VACUUM ANALYZE execution finishes

2018-04-09 Thread Adrian Klaver
On 04/09/2018 03:37 AM, Sebastien Arod wrote: Hi, I face a surprising behaviour with VACUUM ANALYZE. For a table with a structure like like this (and few records): create table my_table (     my_column numeric ); When I run the following: VACUUM ANALYZE my_table; SELECT relname, last_analyze,

pg_stat_all_tables not updated when VACUUM ANALYZE execution finishes

2018-04-09 Thread Sebastien Arod
Hi, I face a surprising behaviour with VACUUM ANALYZE. For a table with a structure like like this (and few records): create table my_table ( my_column numeric ); When I run the following: VACUUM ANALYZE my_table; SELECT relname, last_analyze, last_vacuum FROM pg_stat_all_tables where relnam