Re: Reduction in WAL for UPDATEs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reduction in WAL for UPDATEs
Date
Msg-id 3849.1175100001@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reduction in WAL for UPDATEs  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
"Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at> writes:
> Btw: Do we consider the existance of toasted columns in the seq-scan
> cost estimation ?

Not at present.  There was some discussion of this but it seems like
a fair amount of work --- we don't currently track statistics on how
many of a column's entries are toasted or how big they are.  For that
matter it would be entirely unreasonable to pin the cost on "seq scan";
you'd need to look in close detail at exactly where and how the Vars get
used, and distinguish simply copying a Var from actual use of its value.
The planner is mostly uninterested in the evaluation costs of plan node
targetlists at the moment, and IIRC that's something not so easily
changed...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas ADI SD"
Date:
Subject: Re: Reduction in WAL for UPDATEs
Next
From: "Simon Riggs"
Date:
Subject: Re: Patch queue concern