Re: [GENERAL] How is autovacuum affected by a change in year.

2015-02-26 Thread Hanns Hartman
Hi Tom, Yep I know its out of date but thank you for replying anyways :) I retried my test with the autovacuum logs turned on and confirmed that a postgresql restart fix the issue. thanks your your help! -HH On Thu, Feb 26, 2015 at 11:02 AM, Tom Lane wrote: > Hanns Hartman writes: > > I am r

Re: [GENERAL] How is autovacuum affected by a change in year.

2015-02-26 Thread Tom Lane
Hanns Hartman writes: > I am running postgres 8.3.17 on a RedHat linux derivative using a mips64 > architecture. You realize of course that 8.3 is long out of support ... > I've recently noticed some odd autovacuum behavior. > Recently we've had some systems deployed with the system clock set t

[GENERAL] How is autovacuum affected by a change in year.

2015-02-26 Thread Hanns Hartman
Hi, I am running postgres 8.3.17 on a RedHat linux derivative using a mips64 architecture. I've recently noticed some odd autovacuum behavior. Recently we've had some systems deployed with the system clock set to the year 2016. Postgres was installed with that date and things were fine until a