Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-03 Thread J Sisson
2010/2/1 : > * 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 . > > * joke 2: concurrency update on same row would lead to that other > transaction must wait the earlier transaction comp

Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-02 Thread Greg Smith
Scott Marlowe wrote: I wonder if having paid technical support to abuse leads to people thinking they can treat other people like crap and get the answer they want anyway... You have technical support somewhere you get to abuse? For me it always seems to be the other way around... -- Greg S

Re: [PERFORM] Re: 回复:Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-02 Thread Tom Lane
Richard Broersma writes: > 2010/2/1 : >> yet, this code is just for fun , why ? because i found this code in one >> article:PostgreSQL Concurrency Issues . > I'm not familiar with the "code" that you are referring to. Do you > have a hyper-link to it? >> Tom Lane >> Red Hat Database Group >> R

Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-02 Thread Scott Marlowe
On Tue, Feb 2, 2010 at 9:20 AM, Alvaro Herrera wrote: > Scott Marlowe escribió: >> 2010/2/1  : > >> 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 >> > des

Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-02 Thread Alvaro Herrera
Scott Marlowe escribió: > 2010/2/1 : > 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 lo

Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-02 Thread Scott Marlowe
2010/2/1 : > 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 concu

Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-01 Thread Richard Broersma
On Feb 1, 2010, at 8:57 PM, wyx6...@sina.com wrote: 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: I would suggest that the behavior that you dislike so much is really not idea of the postg

Re: [PERFORM] the jokes for pg concurrency write performance

2010-02-01 Thread david
On Tue, 2 Feb 2010, wyx6...@sina.com wrote: hi, first, thanks u for make so good opensource db . first you thank the developers, then you insult them. are you asking for help or just trying to cause problems. recently maybe half an years ago ,i begin to use pg in a big project for insuran

[PERFORM] the jokes for pg concurrency write performance

2010-02-01 Thread wyx6fox
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