indexing just a part of a string

From: Christoph Pingel <ch(dot)pingel(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: indexing just a part of a string
Date: 2005-02-08 10:50:28
Message-ID: a06100503be2e2d0e341d@[62.224.49.157]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm new to PostgreSQL, and it has been a pleasure so far.

There's just one thing I'm trying to do and I didn't find any hints
in the manual: I want to index just a part of a string in a column.

The situation: I have roughly 300.000 rows, and in the column we're
looking at, most of the entries have less than 200 chars. However,
there are some (very few) that have more than 3000 chars, and
postmaster relplies that this is too many for the index (b-tree).

So I would like to say 'index only the first 200 chars of the
column', which will result in a full index of 99.9 % of my entries. I
did this in MySQL, but I didn't find it in the pg manual.

How do I proceed?

best regards, and TIA
Christoph Pingel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Clements 2005-02-08 10:51:25 Re:
Previous Message Martijn van Oosterhout 2005-02-08 10:48:49 Re: External Projects in the PostgreSQL release