Skip site navigation (1) Skip section navigation (2)

Re: some problems when i use postgresql 8.4.2 in my projects .

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: wyx6fox(at)sina(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: some problems when i use postgresql 8.4.2 in my projects .
Date: 2010-02-03 14:58:18
Message-ID: 603c8f071002030658r54220906jda393a3cfe107912@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
2010/2/2  <wyx6fox(at)sina(dot)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

In response to

pgsql-performance by date

Next:From: Amitabh KantDate: 2010-02-03 15:10:57
Subject: Optimizing Postgresql server and FreeBSD for heavy read and writes
Previous:From: Andres FreundDate: 2010-02-03 14:19:49
Subject: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group