Re: choosing the right locking mode - Mailing list pgsql-general

From Craig Ringer
Subject Re: choosing the right locking mode
Date
Msg-id 47F52C15.5060808@postnewspapers.com.au
Whole thread Raw
In response to Re: choosing the right locking mode  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe wrote:
>>
>>  The serial based approach sounds a fair bit better.
>>
Er, I meant "sequence".
>
> Add prepared select statements and you'd get get pretty fast
> performance.
>
Yep, and if DB round trips are a problem it can always be wrapped up in
a stored procedure. I'd be tempted to do that anyway just to simplify
the client's job, guarantee query plan caching, etc.

--
Craig Ringer

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: choosing the right locking mode
Next
From: rihad
Date:
Subject: Re: deadlock