From: Robert Haas <robertmhaas@gmail.com>
To: wyx6fox@sina.com
Cc: pgsql-performance@postgresql.org
Subject: Re: some problems when i use postgresql 8.4.2 in my projects .
Date: Wed, 3 Feb 2010 09:58:18 -0500
Message-ID: <603c8f071002030658r54220906jda393a3cfe107912@mail.gmail.com> (raw)
In-Reply-To: <20100203022830.2A375358C60@mail175-236.sinamail.sina.com.cn>
References: <20100203022830.2A375358C60@mail175-236.sinamail.sina.com.cn>
2010/2/2 <wyx6fox@sina.com>:
> the unique constraints actualy kill concurrency write transaction when
> concurrency insert violate the unique constraints , they block each other ,
> i test this in oracle10g, has the same behavour. I think this may be
> reasonable because the uqniue check must be the seriazable check .
> for resolve this problem , i do the unique check in application as possible
> , but in big concurrency env , this is not good way .
You may find that your way isn't actually very reliable, and that
making it reliable will be very, very much harder (and likely no
faster) than letting PostgreSQL do it.
...Robert
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: robertmhaas@gmail.com, wyx6fox@sina.com
Subject: Re: some problems when i use postgresql 8.4.2 in my projects .
In-Reply-To: <603c8f071002030658r54220906jda393a3cfe107912@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox