Re: the jokes for pg concurrency write performance

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: wyx6fox(at)sina(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: the jokes for pg concurrency write performance
Date: 2010-02-02 16:20:46
Message-ID: 20100202162046.GA4020@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Marlowe escribió:
> 2010/2/1 <wyx6fox(at)sina(dot)com>:

> 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. "

Yeah, if it had been written this way I could have told him that this
is not the case since 8.1, but since he didn't, I simply skipped his
emails.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2010-02-02 16:27:26 Re: the jokes for pg concurrency write performance
Previous Message Scott Marlowe 2010-02-02 16:12:09 Re: the jokes for pg concurrency write performance