Re: Large CASE-statement is pretty slow? - Mailing list pgsql-performance

From Greg Stark
Subject Re: Large CASE-statement is pretty slow?
Date
Msg-id 87smga2fim.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Large CASE-statement is pretty slow?  (Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl>)
List pgsql-performance
Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl> writes:

> Well, I have discarded this type of query as "too inefficient" and found a
> better way

Loading the mapping into a table with an index and doing an update using
"from" to do a join seems likely to end up being the most efficient method.
Postgres would probably not even bother with the index and do a hash join.


--
greg

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: Large CASE-statement is pretty slow?
Next
From: Arjen van der Meijden
Date:
Subject: Re: Large CASE-statement is pretty slow?