Re: [GENERAL] Indexes on character type columns

2005-12-22 Thread Guido Neitzer
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

Re: [GENERAL] Indexes on character type columns

2005-12-22 Thread Martijn van Oosterhout
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

[GENERAL] Indexes on character type columns

2005-12-22 Thread Guido Neitzer
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