Postgres Pro
Downloads
Home   >   mailing lists

Re: Effect of large text field data on queries - Mailing list pgsql-general

From Tom Lane
Subject Re: Effect of large text field data on queries
Date
Msg-id 25750.1161898174@sss.pgh.pa.us
Whole thread Raw
In response to Re: Effect of large text field data on queries  (Glen Parker <glenebob@nwlink.com>)
List pgsql-general
Tree view 
Glen Parker <glenebob@nwlink.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: schema 8.1.5
Next
From: Andrew Sullivan
Date:
Subject: Re: Compiling ELF 64-bit on Solaris