Re: [HACKERS] Index greater than 8k

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Darcy Buskermolen <darcyb(at)commandprompt(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, PgSQL General <pgsql-general(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Index greater than 8k
Date: 2006-11-01 23:22:01
Message-ID: Pine.GSO.4.63.0611020219010.8413@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, 31 Oct 2006, Joshua D. Drake wrote:

>
> Yes we do (and can) expect to find text among the bytes. We have
> searches running, we are just running into the maximum size issues for
> certain rows.

you can use substr() to be safe, if schema change doesn't available

>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ritesh Nadhani 2006-11-02 02:46:32 Re: Compiling/Installing as a non-admin user
Previous Message Karsten Hilbert 2006-11-01 22:52:06 Re: Encoding, Unicode, locales, etc.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-11-02 06:19:28 Re: Re: ¿¿¿past chunk end???
Previous Message Alvaro Herrera 2006-11-01 22:16:37 Re: [HACKERS] Index greater than 8k