Postgres Pro
Downloads
Home   >   mailing lists

Re: Lots of stuck queries after upgrade to 9.4 - Mailing list pgsql-general

From Spiros Ioannou
Subject Re: Lots of stuck queries after upgrade to 9.4
Date
Msg-id CACKh8C-xLwkyPqQdhKfkGe_fxq0tZwhf3UKCKd_tQaXppUOHng@mail.gmail.com
Whole thread Raw
In response to Re: Lots of stuck queries after upgrade to 9.4  (Andres Freund <andres@anarazel.de>)
Responses Re: Lots of stuck queries after upgrade to 9.4  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-general
Tree view
Debian 6, x64, HP Proliant, dbsize: 3TB on EMC AX-4i (iscsi), 16 cores, 24GB RAM.
kernel: Linux vserver11 2.6.32-5-xen-amd64 #1 SMP Sun Dec 7 22:52:42 UTC 2014 x86_64 GNU/Linux
I attach postgresql.conf



 

Spiros Ioannou 
IT Manager, inAccess
www.inaccess.com

M: +30 6973-903808
T: +30 210-6802-358


On 20 July 2015 at 16:04, Andres Freund <andres@anarazel.de> wrote:
Hi,

On 2015-07-20 15:58:33 +0300, Spiros Ioannou wrote:
> Happened again, another backtrace from a COMMIT process. I changed the
> commit_delay to 0 (it was 4000 to help with our storage) and will report
> back.

What hardware & OS is this happening on?

Regards,

Andres

Attachment

pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: Lots of stuck queries after upgrade to 9.4
Next
From: Rafal Pietrak
Date:
Subject: Re: INSERT ... ON CONFLICT DO UPDATE