Home > mailing lists

best practices with index on varchar column - Mailing list pgsql-performance

From	Layet Benjamin
Subject	best practices with index on varchar column
Date	March 22, 2005 12:23:06
Msg-id	007301c52ec0$a8f64ec0$9285a8c0@moonfactory.co.jp Whole thread Raw
Responses	Re: best practices with index on varchar column (Dawid Kuroczko <qnex42@gmail.com>) Re: best practices with index on varchar column (PFC <lists@boutiquenumerique.com>)
List	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

From: Simon Riggs
Date: 22 March 2005, 11:35:39
Subject: Re: What needs to be done for real Partitioning?

From: Dawid Kuroczko
Date: 22 March 2005, 12:49:42
Subject: Re: best practices with index on varchar column