Re: the jokes for pg concurrency write performance - Mailing list pgsql-performance

From J Sisson
Subject Re: the jokes for pg concurrency write performance
Date
Msg-id 4297a9021002030031k773f25eu8b41c189fac488ec@mail.gmail.com
Whole thread Raw
In response to the jokes for pg concurrency write performance  (wyx6fox@sina.com)
List pgsql-performance
2010/2/1  <wyx6fox@sina.com>:
> * 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 complete , this would kill the
> concurrency performance in some long time transaction situation . a stupid
> design to ,

I hear that MySQL can work wonders in performance by bypassing the
checks you're concerned about...don't count on the data being
consistent, but by golly it'll get to the client FAAAAAAAST...

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: System overload / context switching / oom, 8.3
Next
From: Dimitri Fontaine
Date:
Subject: Re: queries with subquery constraints on partitioned tables not optimized?