Postgres chooses slow query plan from time to time

2021-09-13 Thread Kristjan Mustkivi
Dear community, I have a query that most of the time gets executed in a few milliseconds yet occasionally takes ~20+ seconds. The difference, as far as I am able to tell, comes whether it uses the table Primary Key (fast) or an additional index with smaller size. The table in question is INSERT ON

Re: Postgres chooses slow query plan from time to time

2021-09-13 Thread Tomas Vondra
On 9/13/21 3:24 PM, Kristjan Mustkivi wrote: > Dear community, > > I have a query that most of the time gets executed in a few > milliseconds yet occasionally takes ~20+ seconds. The difference, as > far as I am able to tell, comes whether it uses the table Primary Key > (fast) or an additional in

Re: Postgres chooses slow query plan from time to time

2021-09-13 Thread Michael Lewis
Autovacuum will only run for freezing, right? Insert only tables don't get autovacuumed/analyzed until PG13 if I remember right.

Re: Postgres chooses slow query plan from time to time

2021-09-13 Thread Justin Pryzby
On Mon, Sep 13, 2021 at 08:19:40AM -0600, Michael Lewis wrote: > Autovacuum will only run for freezing, right? Insert only tables don't get > autovacuumed/analyzed until PG13 if I remember right. Tomas is talking about autovacuum running *analyze*, not vacuum. It runs for analyze, except on parti

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

2021-09-13 Thread l...@laurent-hasson.com
> -Original Message- > From: Andrew Dunstan > Sent: Thursday, September 2, 2021 13:00 > To: Julien Rouhaud > Cc: l...@laurent-hasson.com; Tom Lane ; Ranier > Vilela ; Justin Pryzby ; > pgsql-performa...@postgresql.org > Subject: Re: Big Performance drop o

Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

2021-09-13 Thread Andrew Dunstan
On 9/13/21 10:32 AM, l...@laurent-hasson.com wrote: > > Hello all, > > Any further update or guidance on this issue at this time? > Wait for a new installer. Our team is working on it. As I have previously advised you, please be patient. cheers andrew -- Andrew Dunstan EDB: https://www.ente

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

2021-09-13 Thread l...@laurent-hasson.com
> -Original Message- > From: Andrew Dunstan > Sent: Monday, September 13, 2021 11:36 > To: l...@laurent-hasson.com; Julien Rouhaud > Cc: Tom Lane ; Ranier Vilela ; > Justin Pryzby ; pgsql- > performa...@postgresql.org > Subject: Re: Big Performance drop o

Re: Postgres chooses slow query plan from time to time

2021-09-13 Thread Jeff Janes
On Mon, Sep 13, 2021 at 9:25 AM Kristjan Mustkivi wrote: > SELECT > * > FROM > myschema.mytable pbh > WHERE > pbh.product_code = $1 > AND pbh.cage_player_id = $2 > AND pbh.cage_code = $3 > AND balance_type = $4 > AND pbh.modified_time < $5 > ORDER BY > pbh.modifie

Re: Postgres chooses slow query plan from time to time

2021-09-13 Thread Jeff Janes
On Mon, Sep 13, 2021 at 9:25 AM Kristjan Mustkivi wrote: > > I have caught this with AUTOEXPLAIN: > > Index Cond: ((cage_code = $3) AND (cage_player_id = $2) AND > (modified_time < $5)) > Filter: (((product_code)::text = ($1)::text) AND > ((balance_type)::text = ($4)::text)) >

Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

2021-09-13 Thread Andrew Dunstan
On 9/13/21 11:53 AM, l...@laurent-hasson.com wrote: > >> -Original Message- >> From: Andrew Dunstan >> Sent: Monday, September 13, 2021 11:36 >> To: l...@laurent-hasson.com; Julien Rouhaud >> Cc: Tom Lane ; Ranier Vilela ; >> Justin Pryzby ; pgsql- >>

EnterpriseDB

2021-09-13 Thread Mladen Gogala
The company I work for will test EnterpriseDB. I am fairly well acquainted with Postgres but have no experience whatsoever with EnterpriseDB. How compatible to Postgres it is? Do pgAdmin4 and pgBadger work with EnterpriseDB? Are psql commands the same? Can anyone here share some impressions?