Re: Easy question - Mailing list pgsql-performance

From mlartz@gmail.com
Subject Re: Easy question
Date
Msg-id 1146483320.091670.38040@u72g2000cwu.googlegroups.com
Whole thread Raw
In response to Easy question  (clemens.bertschler@gmail.com)
List 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.


pgsql-performance by date:

Previous
From: Scott Sipe
Date:
Subject: Super-smack?
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: Super-smack?