Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 26 Oct 2006 16:41:30 -0400
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
- Follow-Ups:
- Re: Effect of large text field data on queries
- From: Glen Parker
- Re: Effect of large text field data on queries
- References:
- Effect of large text field data on queries
- From: Glen Parker
- Re: Effect of large text field data on queries
- From: Tom Lane
- Re: Effect of large text field data on queries
- From: Glen Parker
- Effect of large text field data on queries
- Prev by Date: Re: Effect of large text field data on queries
- Next by Date: schema 8.1.5
- Previous by thread: Re: Effect of large text field data on queries
- Next by thread: Re: Effect of large text field data on queries
- Indexes: