Search Postgresql Archives

Re: Effect of large text field data on queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Glen Parker <glenebob@xxxxxxxxxx>
Subject: Re: Effect of large text field data on queries
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 26 Oct 2006 17:29:34 -0400
Cc: Postgres General <pgsql-general@xxxxxxxxxxxxxx>
Comments: In-reply-to Glen Parker <glenebob@xxxxxxxxxx> message dated "Thu, 26 Oct 2006 14:14:04 -0700"
In-reply-to: <4541251C.2080503@xxxxxxxxxx>
References: <454111B5.90001@xxxxxxxxxx> <24951.1161894402@xxxxxxxxxxxxx> <45411B5A.9040905@xxxxxxxxxx> <25122.1161895290@xxxxxxxxxxxxx> <4541251C.2080503@xxxxxxxxxx>

Glen Parker <glenebob@xxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
- Re: Effect of large text field data on queries
  - From: Tom Lane
- Re: Effect of large text field data on queries
  - From: Glen Parker

Prev by Date: Re: schema 8.1.5
Next by Date: Re: Compiling ELF 64-bit on Solaris
Previous by thread: Re: Effect of large text field data on queries
Next by thread: Re: Effect of large text field data on queries
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux