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

From Andres Freund
Subject Re: Lots of stuck queries after upgrade to 9.4
Date
Msg-id 20150720140243.GD5520@alap3.anarazel.de
Whole thread Raw
In response to Re: Lots of stuck queries after upgrade to 9.4  (Spiros Ioannou <sivann@inaccess.com>)
Responses Re: Lots of stuck queries after upgrade to 9.4  (Spiros Ioannou <sivann@inaccess.com>)
List pgsql-general
On 2015-07-20 17:00:52 +0300, Spiros Ioannou wrote:
> FYI we have an 9.3.5 with commit_delay = 4000 and commit_siblings = 5 with
> a 8TB dataset which seems fine. (Runs on different - faster hardware
> though).

9.4 has a different xlog insertion algorithm (scaling much better), so
that unfortunately doesn't say very much...


pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: INSERT ... ON CONFLICT DO UPDATE
Next
From: Alvaro Herrera
Date:
Subject: Re: INSERT ... ON CONFLICT DO UPDATE