Re: Easy question

From: "Bert" <clemens(dot)bertschler(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Easy question
Date: 2006-04-30 00:07:59
Message-ID: 1146355679.311472.57800@u72g2000cwu.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bealach-na Bo 2006-04-30 10:29:55 Re: Why so slow?
Previous Message chris smith 2006-04-29 23:51:44 Re: Worsening performance with 7.4 on flash-based system