Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance and doing USENET style threaded messages - Mailing list pgsql-general

From Tom Lane
Subject Re: Performance and doing USENET style threaded messages
Date
Msg-id 24890.977591611@sss.pgh.pa.us
Whole thread Raw
In response to Performance and doing USENET style threaded messages  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Tree view 
Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> What is the recommended max indexable text length in Postgresql 7.0?

btree indexes have a hard limit at 1/3rd of a block --- it works out
to be exactly 2700 bytes for 8K blocks.  Not sure whether performance
drops off before that.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database I/O and other performance questions.
Next
From: "Abe"
Date:
Subject: Lower record