Skip site navigation (1)
Skip section navigation (2)
You have a functional index on UPPER(municipo), right? How large is the table?
Peripheral Links
Header And Logo
|
Site Navigation
Re: Easy question
- From: "Michael Artz" <mlartz(at)gmail(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Easy question
- Date: Sat, 29 Apr 2006 17:53:10 -0400
You have a functional index on UPPER(municipo), right? How large is the table?
On 26 Apr 2006 18:26:07 -0700, Bert <
clemens(dot)bertschler(at)gmail(dot)com> wrote:
Thanks,
But the performance is the same just the formating is more simple.
Greets,
Bert
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
- References:
- Easy question
- From: clemens . bertschler
- Re: Easy question
- From: codeWarrior
- Re: Easy question
- From: Bert
- Easy question
- Prev by Date: Re: Worsening performance with 7.4 on flash-based system
- Next by Date: Re: Worsening performance with 7.4 on flash-based system
- Previous by thread: Re: Easy question
- Next by thread: GROUP BY Vs. Sub SELECT
- Indexes: