Re: On the usefulness of hint bits

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: On the usefulness of hint bits
Date: 2010-10-11 15:30:54
Message-ID: 514323.74444.qm@web29003.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I wonder if we could improve this with some sort of process-local
> cache - not to get rid of hint bits, just to reduce pg_clog
> contention. We might easily end up testing the same XID many times
> during the same table scan.


I guess that's my scenario... not that many transactions, so even
"copying" the whole pg_clog table in the per-process memory would
be doable...

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-10-11 15:44:08 Re: wip: functions median and percentile
Previous Message Dean Rasheed 2010-10-11 15:30:46 Re: wip: functions median and percentile