Re: [HACKERS] last_analyze/last_vacuum not being updated

2015-06-17 Thread Peter Eisentraut
On 6/15/15 4:45 PM, Peter Eisentraut wrote: > On 6/8/15 3:16 PM, Peter Eisentraut wrote: >> I'm looking at a case on 9.4.1 where the last_analyze and last_vacuum >> stats for a handful of tables seem stuck. They don't update after >> running an ANALYZE or VACUUM command, and they don't react to >>

Re: [HACKERS] last_analyze/last_vacuum not being updated

2015-06-15 Thread Peter Eisentraut
On 6/8/15 3:16 PM, Peter Eisentraut wrote: > I'm looking at a case on 9.4.1 where the last_analyze and last_vacuum > stats for a handful of tables seem stuck. They don't update after > running an ANALYZE or VACUUM command, and they don't react to > pg_stat_reset_single_table_counters(). All of th

Re: [HACKERS] last_analyze/last_vacuum not being updated

2015-06-08 Thread Tom Lane
Peter Eisentraut writes: > I'm looking at a case on 9.4.1 where the last_analyze and last_vacuum > stats for a handful of tables seem stuck. They don't update after > running an ANALYZE or VACUUM command, and they don't react to > pg_stat_reset_single_table_counters(). All of the affected tables

Re: [HACKERS] last_analyze/last_vacuum not being updated

2015-06-08 Thread Alvaro Herrera
Peter Eisentraut wrote: > I'm looking at a case on 9.4.1 where the last_analyze and last_vacuum > stats for a handful of tables seem stuck. They don't update after > running an ANALYZE or VACUUM command, and they don't react to > pg_stat_reset_single_table_counters(). All of the affected tables a

[HACKERS] last_analyze/last_vacuum not being updated

2015-06-08 Thread Peter Eisentraut
I'm looking at a case on 9.4.1 where the last_analyze and last_vacuum stats for a handful of tables seem stuck. They don't update after running an ANALYZE or VACUUM command, and they don't react to pg_stat_reset_single_table_counters(). All of the affected tables are system catalogs, some shared,