Re: HeapTupleSatisfiesToast not setting XMIN_COMMITTED?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: HeapTupleSatisfiesToast not setting XMIN_COMMITTED?
Date: 2011-09-21 20:02:41
Message-ID: 28150.1316635361@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> I notice that HeapTupleSatisfiesToast is not setting the
> HEAP_XMIN_COMMITTED bit, though it is reading it. Is there a reason for
> this? It seems to me that it'd make sense to have it set ... unless
> it's set by some other routine, somehow?

Hmm ... I wonder if that has something to do with the performance
complaints we sometimes get about TOAST. VACUUM would presumably set
the bit, but in a never-vacuumed toast table this could be a problem.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-09-21 20:05:06 Re: HeapTupleSatisfiesToast not setting XMIN_COMMITTED?
Previous Message Euler Taveira de Oliveira 2011-09-21 19:47:43 Re: unaccent contrib