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

2010-02-03 Thread Pierre Frédéric Caillau d
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 poss

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

2010-02-03 Thread Leo Mannhart
wyx6...@sina.com wrote: > after shaming , I think i should pick out some my points: > 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

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

2010-02-03 Thread Robert Haas
2010/2/2 : >  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 ch

[PERFORM] some problems when i use postgresql 8.4.2 in my projects .

2010-02-02 Thread wyx6fox
Sorry again for previous rough messages,  some good people advice me to post these problems again With sincere and friendly attitude 。 I think i should do this . In recently projects , I determine use pg in some medium or big projects , as the projects has been finished,  it prove that I made