Re: concurrent writes - Mailing list pgsql-general

From Dennis Gearon
Subject Re: concurrent writes
Date
Msg-id 3F2692F8.7070305@cvc.net
Whole thread Raw
In response to concurrent writes  (Andreas Jung <andreas.jung@haufe.de>)
List pgsql-general
If I understand your idea, and Postgres, this is like saying you want multiple backend processes, and definite, "NO".
Asfar as I know, one connection == 1 xaction. 

Andreas Jung wrote:
> hi,
>
> we are running Postgres 7.3.3 successfully on our portal sites
> under Solaris. For a new project we have the requirement that
> N processes need to write update/insert within the same time and within
> the same transaction data in one table. More detailed: every process
> opens its own connection, starts a transaction, updates *different* rows
> and then commits. According to our postgres adminstrator, Postgres seems
> to behave differently on Linux and Solaris. Any ideas on that?
>
> Thanks,
> Andreas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>


pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: CREATE TABLE with REFERENCE
Next
From: Francisco Reyes
Date:
Subject: Auto completion in psql