Re: Performance bug in prepared statement binding in 9.2?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance bug in prepared statement binding in 9.2?
Date: 2013-08-01 17:58:16
Message-ID: 51FAA1B8.6040809@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Amit, All:

So we just retested this on 9.3b2. The performance is the same as 9.1
and 9.2; that is, progressively worse as the test cycles go on, and
unacceptably slow compared to 8.4.

Some issue introduced in 9.1 is causing BINDs to get progressively
slower as the PARSEs BINDs get run repeatedly. Per earlier on this
thread, that can bloat to 200X time required for a BIND, and it's
definitely PostgreSQL-side.

I'm trying to produce a test case which doesn't involve the user's
application. However, hints on other things to analyze would be keen.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2013-08-01 18:23:54 Re: Looks like merge join planning time is too big, 55 seconds
Previous Message David Kerr 2013-08-01 17:58:03 Re: Looks like merge join planning time is too big, 55 seconds