Re: Effect of large text field data on queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Glen Parker <glenebob(at)nwlink(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Effect of large text field data on queries
Date: 2006-10-26 20:41:30
Message-ID: 25122.1161895290@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Glen Parker <glenebob(at)nwlink(dot)com> writes:
> How much of a TOAST'd field is actually stored in the main heap table?
> Is there a way to configure that amount?

A pushed-out-of-line value is replaced by a 20-byte pointer structure.
There's no such thing as partially out-of-line. See
http://www.postgresql.org/docs/8.1/static/storage-toast.html

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message km 2006-10-26 21:04:51 schema 8.1.5
Previous Message Alan Hodgson 2006-10-26 20:36:08 Re: Effect of large text field data on queries