We have plans to upgrade to a later version of postgres, but that could take a while.
Meantime, I wanted to understand whether the autovacuum failure could be linked to the fact that the stats collector could not update (rename) the pgstats file?
Thanks and Regards,
Subhasis
On Fri, Nov 23, 2012 at 6:35 PM, Craig Ringer <craig@xxxxxxxxxxxxxxx> wrote:
On 11/23/2012 07:32 PM, Subhasis Bhattacharya wrote:8.3?
> Hi All,
>
> Recently a postgres database embedded within our product faced a
> series of hiccups at a customer site, as follows:
An old 8.3 at that?
Do you have any upgrade plans? I'm pretty sure I remember seeing this
discussed a long time ago, but it hasn't come up recently.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services