On 22.12.2005, at 11:27 Uhr, Martijn van Oosterhout wrote:
For btrees at least, yes. Around a third of a page or about 2713 bytes
by default. For bigger things you probably want tsearch anyway.
Thanks.
cug
smime.p7s
Description: S/MIME cryptographic signature
On Thu, Dec 22, 2005 at 11:24:12AM +0100, Guido Neitzer wrote:
> Hi.
>
> Is there a limitation of the length of a char or varchar(x) column
> for indexing?
For btrees at least, yes. Around a third of a page or about 2713 bytes
by default. For bigger things you probably want tsearch anyway.
Hav
Hi.
Is there a limitation of the length of a char or varchar(x) column
for indexing?
cug
smime.p7s
Description: S/MIME cryptographic signature