Postgres Pro
Downloads
Home   >   mailing lists

Re: Varchar Indexing - Mailing list pgsql-general

From Tom Lane
Subject Re: Varchar Indexing
Date
Msg-id 13155.981670760@sss.pgh.pa.us
Whole thread Raw
In response to Varchar Indexing  (mitch <mitch@venux.net>)
List pgsql-general
Tree view 
mitch <mitch@venux.net> writes:
> Is there a size limit on indexable varying character fields?

1/3rd page, about 2700 bytes, if you're using btree index.

Presently, TOAST does not help any :-(

            regards, tom lane

pgsql-general by date:

Previous
From: "Brent R.Matzelle"
Date:
Subject: Indicies and write performance
Next
From: Alfonso Peniche
Date:
Subject: About SP's and parameters