Skip site navigation (1) Skip section navigation (2)  Re: TOAST
usage setting  Cc: "Zeugswetter Andreas ADI SD"
<ZeugswetterA(at)spardat(dot)at>, "Bruce Momjian"
<bruce(at)momjian(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: TOAST usage setting Date: 2007-05-30 16:00:23
Message-ID: (view raw or flat) Lists: pgsql-hackers  > The
shorter-than-normal tuples carrying the last chunk of any
particular > datum are going to result in wasted space to the
extent that we can't > pack them together on a page, but that's
true now.  Right now, if you > have a large toasted datum, it
mostly will consist of just-under-2K > tuples that are sized so
that there's no noticeable wasted space on a > page with 4 of
them.  There isn't any advantage to that compared to one > just-
under-8K tuple AFAICS, and it takes 4 times as much work to
insert > or retrieve 'em.  That will be true if your data are
usually larger than 8k. But if your data are all between
TOAST_TUPLE_THRESHOLD and TOAST_MAX_CHUNK_SIZE you won't have an