Horton

Re: SSI performance

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-02-04T16:07:41Z
Lists: pgsql-hackers 
On 04.02.2011 15:37, Robert Haas wrote:
> Not sure.  How much benefit do we get from upgrading tuple locks to
> page locks?  Should we just upgrade from tuple locks to full-relation
> locks?

Hmm, good question. Page-locks are the coarsest level for the b-tree 
locks, but maybe that would make sense for the heap.

> It also seems like there might be some benefit to caching the
> knowledge that we have a full-relation lock somewhere, so that once we
> get one we needn't keep checking that.  Not sure if that actually
> makes sense...

Well, if you reverse the order of the hash table lookups, that's 
effectively what you get.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com