Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group