best practices with index on varchar column

From: "Layet Benjamin" <benjamin(at)moonfactory(dot)co(dot)jp>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: best practices with index on varchar column
Date: 2005-03-22 09:22:24
Message-ID: 007301c52ec0$a8f64ec0$9285a8c0@moonfactory.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi everyone,
I hope it is the correct newsletter for this question.

Can I use an index on a varchar column to optimize the SELECT queries that
use " column LIKE 'header%' "?
If yes what is the best tree algotithm to use ?

I don't care about optimising INSERT, DELETE and UPDATE queries, as they are
only done at night when the load is very low.
Thank you very much for any help,
Benjamin Layet

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dawid Kuroczko 2005-03-22 09:49:25 Re: best practices with index on varchar column
Previous Message Simon Riggs 2005-03-22 08:34:22 Re: What needs to be done for real Partitioning?