Re: HOT TOAST?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: HOT TOAST?
Date: 2008-02-13 18:04:39
Message-ID: 20169.1202925879@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)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

In response to

  • HOT TOAST? at 2008-02-13 17:50:15 from Josh Berkus

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tore Halset 2008-02-13 19:45:01 Re: Dell Perc/6
Previous Message Alex Deucher 2008-02-13 17:58:03 Re: Anyone using a SAN?