Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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 17:29:34 -0400
  • Message-id: <25750(dot)1161898174(at)sss(dot)pgh(dot)pa(dot)us>
Glen Parker <glenebob(at)nwlink(dot)com> writes:
> How can I determine the default storage type for a given TOASTable
> data type (text in this case)?

Look in pg_type ... but they mostly default to "extended".

			regards, tom lane
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group