Postgres Pro
Downloads
Home   >   mailing lists

Re: Please help! Query jumps from 1s -> 4m - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: Please help! Query jumps from 1s -> 4m
Date
Msg-id 20200504191201.GU28974@telsasoft.com
Whole thread Raw
In response to Please help! Query jumps from 1s -> 4m  (James Thompson <james@jthompson.dev>)
Responses Re: Please help! Query jumps from 1s -> 4m  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view 
On Mon, May 04, 2020 at 08:07:07PM +0100, Jamie Thompson wrote:
> Additionally, the execution plans for the 10th + following queries look
> fine, they have the same structure as if I run the query manually. It's not
> that the query plan switches, it seems as though the same query plan is
> just > 200X slower than usual.

Are you able to reproduce the problem manually ?

With/without PREPARE ?
https://www.postgresql.org/docs/current/sql-prepare.html

-- 
Justin

pgsql-performance by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Duplicate WHERE condition changes performance and plan
Next
From: James Thompson
Date:
Subject: Re: Please help! Query jumps from 1s -> 4m