On 8/7/2016 10:26 AM, Philippe Girolami wrote:
More weirdness this afternoon : the wraparound ERROR showed up again even
though I have trouble believing I burned through so many transactions in under
a day. But let’s assume I did, here is what I noticed
1) I vacuumed all other databases. For everyone of those, the age went down to
50M instead of zero. Is that normal ?
2) The only database that didn’t work on was template0 (the age did not
change). It did work on template1
Should I suspect something fishy going on ?
do you have any long running 'idle in transaction' sessions? these would
show up in pg_stat_activity, you want to look at now()-xact_start to see
the age of the oldest of these. no tuples newer than the oldest
xact_start can be vacuumed.
select * from pg_stat_activity where state='idle in transaction';
select count(*), max(now()-xact_start) from pg_stat_activity where
state='idle in transaction';
--
john r pierce, recycling bits in santa cruz
