From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: SubtransControlLock and performance problems
Date: Wed, 19 Feb 2020 12:23:53 -0300
Message-ID: <20200219152353.GA2663@alvherre.pgsql> (raw)
In-Reply-To: <HE1P189MB0266DD7C39B4A4C5D174D5269D100@HE1P189MB0266.EURP189.PROD.OUTLOOK.COM>
On 2020-Feb-19, Lars Aksel Opsahl wrote:
> With the values above I did see same performance problems and we ended
> with a lot of subtransControlLock.
>
> So I started to change the code based on your feedbacks.
>
> - What seems to work very good in combination with a catch exception
> and retry pattern is to insert the data in to separate table for each
> job. (I the current testcase we reduced the number of
> subtransControlLock from many hundreds to almost none.)
I think at this point your only recourse is to start taking profiles to
see where the time is going. Without that, you're just flying blind and
whatever you do will not necessarily move your needle at all.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@2ndquadrant.com, Lars.Opsahl@nibio.no, laurenz.albe@cybertec.at, pavel.stehule@gmail.com, tgl@sss.pgh.pa.us, pgsql-performance@lists.postgresql.org
Subject: Re: SubtransControlLock and performance problems
In-Reply-To: <20200219152353.GA2663@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox