2010/2/1 <wyx6fox@sina.com>:
> hi, first, thanks u for make so good opensource db .
>
> recently maybe half an years ago ,i begin to use pg in a big project for
> insurance project, belong as the project go on ,and
>
> i found some performance problem on concurrency write situation , then i do
> a research on concurrency write strategy on postgresql ,
>
> i found a joke ,maybe this joke concurrency strategy is the designer's
> pround idea, but i think it is a joke , next let me describe the problems:
Please try not to insult the people you're asking for help. Maybe a
little less inflamatory language. Something like "It seems that there
are some issues with concurrency" would work wonders. It's amazing
how much better a response you can get wihtout insulting everybody on
the list, eh?
Let's rewrite this assertion:
> * joke 1: insert operation would use a excluse lock on reference row by the
> foreign key . a big big big performance killer , i think this is a stupid
> design .
"problem #1: insert operation would use a excluse lock on reference row by the
foreign key . a big big big performance killer. "
Then post an example of how it affects your performance. Did you go
to the page that was pointed out to you in a previous post on how to
post effectively about pg problems and get a useful answer? If not,
please do so, and re-post your questions etc without all the insults
and hand waving.