Re: HOT TOAST? - Mailing list pgsql-performance

From Tom Lane
Subject Re: HOT TOAST?
Date
Msg-id 20169.1202925879@sss.pgh.pa.us
Whole thread Raw
In response to HOT TOAST?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: HOT TOAST?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> Does anyone know if HOT is compatible with pg_toast tables, or do TOASTed rows
> simply get excluded from HOT?

The current TOAST code never does any updates, only inserts/deletes.
But the HOT logic should be able to reclaim deleted rows early via
pruning.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Alex Deucher"
Date:
Subject: Re: Anyone using a SAN?
Next
From: Tore Halset
Date:
Subject: Re: Dell Perc/6