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

From Heikki Linnakangas
Subject Re: Exponential processing time for multiple SELECT FOR UPDATE / UPDATE in a single transaction with PostgreSQL 9.x ?
Date
Msg-id 54819B33.3070206@vmware.com
Whole thread Raw
In response to Re: Exponential processing time for multiple SELECT FOR UPDATE / UPDATE in a single transaction with PostgreSQL 9.x ?  (Nathanael Terrien <nte@mustinformatique.fr>)
List 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
functioncalled 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



pgsql-odbc by date:

Previous
From: Nathanael Terrien
Date:
Subject: Re: Exponential processing time for multiple SELECT FOR UPDATE / UPDATE in a single transaction with PostgreSQL 9.x ?
Next
From: Alvaro Herrera
Date:
Subject: Re: Exponential processing time for multiple SELECT FOR UPDATE / UPDATE in a single transaction with PostgreSQL 9.x ?