Re: Easy question - Mailing list pgsql-performance

From Bert
Subject Re: Easy question
Date
Msg-id 1146355679.311472.57800@u72g2000cwu.googlegroups.com
Whole thread Raw
In response to Re: Easy question  ("Michael Artz" <mlartz@gmail.com>)
Responses Re: Easy question  (Chris <dmagick@gmail.com>)
List pgsql-performance
No i didn't defined any indexes for the table, I know the performance
will increase with an index, but this was not my question. My question
furthermore belongs to the access mode of the SQL statement.
Furthermore i do not understand why the Upper function should increase
the performance.
The table has approximately 20.000 entries.
Is it the best way to use a B-Tree index on the municipio column in
this case or are there better solution to do this.


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Nested loop join and date range query
Next
From: Eric Lam
Date:
Subject: Re: Slow restoration question