Re: concurrent writes

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: andreas(dot)jung(at)haufe(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: concurrent writes
Date: 2003-07-29 15:30:00
Message-ID: 3F2692F8.7070305@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

If I understand your idea, and Postgres, this is like saying you want multiple backend processes, and definite, "NO". As far 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2003-07-29 15:58:21 Auto completion in psql
Previous Message Francisco J Reyes 2003-07-29 15:00:15 Re: Hardware selection

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-07-29 15:49:19 Re: Make clean fails
Previous Message Dani Oderbolz 2003-07-29 15:23:22 Re: an aggregate array function