Re: slow get_actual_variable_range with long running transactions

2020-06-16 Thread Marc Cousin
On 16/06/2020 18:28, Marc Cousin wrote: > Oh, sorry about that, I forgot to detail this. I tested on both 10.13 (which > is the production environment on which we faced this), and on 12.3, with the > same problem. > > On 16/06/2020 17:51, Tom Lane wrote: >> Marc Cousin

Re: slow get_actual_variable_range with long running transactions

2020-06-16 Thread Marc Cousin
Oh, sorry about that, I forgot to detail this. I tested on both 10.13 (which is the production environment on which we faced this), and on 12.3, with the same problem. On 16/06/2020 17:51, Tom Lane wrote: > Marc Cousin writes: >> Of course, what happens here is that the histogram says

slow get_actual_variable_range with long running transactions

2020-06-16 Thread Marc Cousin
Hi, We're having an issue with planner performance when doing large deletes at the same time as we have long running transactions, from what we gathered, because of the scan to find the actual minimum and maximum values of the table. Instead of trying to explain what happens, here is a very sim

Re: [PATCH] fix a performance issue with multiple logical-decoding walsenders

2020-01-06 Thread Marc Cousin
Hi, I spent a little bit of time trying to explain the problem we are facing clearly, and provide a reproducible benchmark. So here it is. What triggered our investigation is that we have a PostgreSQL cluster containing about 15 databases, most of them being used as sources for logical repli

Re: Avoid full GIN index scan when possible

2019-07-01 Thread Marc Cousin
On 29/06/2019 00:23, Julien Rouhaud wrote: > On Fri, Jun 28, 2019 at 10:16 PM Tom Lane wrote: >> >> Tomas Vondra writes: >>> On Fri, Jun 28, 2019 at 03:03:19PM -0400, Tom Lane wrote: I not only don't want that function in indxpath.c, I don't even want it to be known/called from there.

best way to check identical constraint between databases

2018-02-05 Thread Marc Cousin
Hi all, I'm trying to extend pg_tap/pg_tapgen in order to be able to check that two databases have the exact same constraints (for all available types of constraints). I am wondering if there is a better way to check that two constraints are equal than using pg_get_constraintdef, which is