| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SSI performance |
| Date: | 2011-02-04 16:07:41 |
| Message-ID: | 4D4C244D.7010107@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2011-02-04 16:16:29 | Re: Re: patch: fix performance problems with repated decomprimation of varlena values in plpgsql |
| Previous Message | Scott Marlowe | 2011-02-04 16:05:32 | Re: [HACKERS] Slow count(*) again... |