From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Making hash indexes worthwhile |
Date: | 2009-10-31 04:25:25 |
Message-ID: | 28292.1256963125@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Jeff Janes <jeff(dot)janes(at)gmail(dot)com> writes:
> So my conclusions are:
> 2) Heavy-weight locks are called that for a reason, they use a lot of
> CPU even without contention.
> 3) The CPU usage of the hash-index code proper is quite small, with
> more time being spent in heavy-weight PageLocks (specific to hash
> indexes, but not part of the hash index code itself) and in executor
> code common to all index methods, than in the hash index code.
Interesting. My reaction to that would be to try to replace the
heavyweight locks with LWLocks. IIRC the reason for using heavyweight
locks was fear of deadlocks, but maybe closer analysis and some tweaking
would allow us to eliminate that risk.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2009-10-31 05:11:24 | Re: Patch set under development to add usage reporting. |
Previous Message | Greg Smith | 2009-10-31 03:00:27 | Re: Patch set under development to add usage reporting. |