Recursive query performance issue

From: Jamie Koceniak <jkoceniak(at)mediamath(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Recursive query performance issue
Date: 2015-10-20 17:34:35
Message-ID: BY2PR12MB07112FB4930B197E0CAB3307A4390@BY2PR12MB0711.namprd12.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Version:
-----------------------------------------------------------------------------------------------
PostgreSQL 9.1.14 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit

Query Plan
http://explain.depesz.com/s/4s37

Normally, this query takes around 200-300 ms to execute.
However when several queries are run concurrently, query performance drops to 30-60 seconds.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2015-10-21 07:03:37 Re: Recursive query performance issue
Previous Message Pavel Stehule 2015-10-20 15:01:54 Re: SELECT slows down on sixth execution