Re: strange slow query performance - Mailing list pgsql-general

From David G. Johnston
Subject Re: strange slow query performance
Date
Msg-id CAKFQuwZmcVzXnSHo6WVpYSqSBiMZ09mwtybwoZ2e8WfS0tWe5A@mail.gmail.com
Whole thread Raw
In response to strange slow query performance  (Ben Snaidero <bensnaidero@geotab.com>)
Responses Re: strange slow query performance  (Ben Snaidero <bensnaidero@geotab.com>)
List pgsql-general
On Thu, Jan 17, 2019 at 9:19 AM Ben Snaidero <bensnaidero@geotab.com> wrote:
> Any ideas as to why this is happening?

Not really, I would expect roughly double execution time, not an
exponential increase.  Still not experienced enough to diagnose with
what has been provided but I will suggest you provide the version that
you are running these queries against and confirm that the results are
consistent across multiple runs to discount the possibility that
locking or other transient work is involved.

Curious if increasing work_mem helps but its mostly a trial-and-error
thing for me (I wouldn't expect it to)...

David J.


pgsql-general by date:

Previous
From: Michel Pelletier
Date:
Subject: Re: Varlena with recursive data structures?
Next
From: Rich Shepard
Date:
Subject: Re: Refining query statement