Re: [SQL] can i make this sql query more efficiant? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: [SQL] can i make this sql query more efficiant?
Date
Msg-id 200304041126.14530.josh@agliodbs.com
Whole thread Raw
In response to Re: [SQL] can i make this sql query more efficiant?  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: [SQL] can i make this sql query more efficiant?
List pgsql-performance
Manfred,

> I'd be honestly interested in the circumstances where you made that
> observation.

Hmmmm ... one of my database involves a "crosstab" converstion where there
were 13 possible values, and the converted table is heavily indexed.  For
that case, I found using CASE statements to be slower.

For your example, how do the statistics change if you increase the number of
levels to 15 and put an index on them?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: [SQL] can i make this sql query more efficiant?
Next
From: Will LaShell
Date:
Subject: Re: ext3 filesystem / linux 7.3