Re: Reducing overhead for repeat de-TOASTing

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Reducing overhead for repeat de-TOASTing
Date: 2008-06-17 12:18:54
Message-ID: A959131D-B4CF-4059-9BB3-7DDF3E596ADC@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Jun 16, 2008, at 3:35 PM, Tom Lane wrote:

>
> to a cache entry rather than a freshly palloc'd value. The cache
> lookup
> key is the toast table OID plus value OID. Now pg_detoast_datum()
> has no
...
> the result of decompressing an inline-compressed datum, because
> those have
> no unique ID that could be used for a lookup key. This puts a bit
> of a

Wouldn't the tid fit this? or table oid + tid?

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.stuarthamm.net/
http://www.dellsmartexitin.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2008-06-17 12:54:43 Re: Crash in pgCrypto?
Previous Message Andrew Dunstan 2008-06-17 11:43:37 Re: pltcl broken on tcl8.5 ?