Re: Easy question

From: "mlartz(at)gmail(dot)com" <mlartz(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Easy question
Date: 2006-05-01 11:35:20
Message-ID: 1146483320.091670.38040@u72g2000cwu.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I can't speak to "the access mode of the SQL statement" but it looks
like the index that you are looking for is an index on an expression,
as shown in:

http://www.postgresql.org/docs/8.0/static/indexes-expressional.html

You probably want a btree on UPPER(municipo), if that is the primary
query method for the column.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2006-05-01 11:54:49 Re: Super-smack?
Previous Message Scott Sipe 2006-05-01 08:05:54 Super-smack?