Re: Exponential processing time for multiple SELECT FOR UPDATE / UPDATE in a single transaction with PostgreSQL 9.x ?

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Nathanael Terrien <nte(at)mustinformatique(dot)fr>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Exponential processing time for multiple SELECT FOR UPDATE / UPDATE in a single transaction with PostgreSQL 9.x ?
Date: 2014-12-05 11:46:59
Message-ID: 54819B33.3070206@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 12/05/2014 01:03 PM, Nathanael Terrien wrote:
>> Maybe. Or just changed behavior between 8.4 and 9.0.
>
> The tests we performed with other connection methods don't slow down (Omnis Studio + PGDAM, C# + npgsql, or just a function called multiple times in the same query window from pgAdmin).
>
>> Could you write a self-contained test case to demonstrate this?
>
> Yes.

Thanks!

> Do you mind if it's a DotNet EXE ?

I'd prefer plain C, I don't have a .net development environment
installed. But if you write a short .net program to reproduce it, I
should be able to rewrite it in C pretty quickly, as long as you provide
the sources.

- Heikki

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Alvaro Herrera 2014-12-05 11:59:19 Re: Exponential processing time for multiple SELECT FOR UPDATE / UPDATE in a single transaction with PostgreSQL 9.x ?
Previous Message Nathanael Terrien 2014-12-05 11:03:05 Re: Exponential processing time for multiple SELECT FOR UPDATE / UPDATE in a single transaction with PostgreSQL 9.x ?