Re: [HACKERS] Deadlocks in HS (on 9.0 :( )

2014-07-16 Thread Andres Freund
On 2014-07-15 16:54:05 +0100, Greg Stark wrote: We've observed a 9.0 database have undetected deadlocks repeatedly in hot standby mode. I think what's happening is that autovacuum is kicking off a VACUUM of some system catalogs -- it seems to usually be pg_statistics' toast table actually.

Re: [HACKERS] Deadlocks in HS (on 9.0 :( )

2014-07-15 Thread Noah Misch
On Tue, Jul 15, 2014 at 04:54:05PM +0100, Greg Stark wrote: We've observed a 9.0 database have undetected deadlocks repeatedly in hot standby mode. I think what's happening is that autovacuum is kicking off a VACUUM of some system catalogs -- it seems to usually be pg_statistics' toast