Request a Demo
Home   >   mailing lists

Re: immutable functions vs. join for lookups ? - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: immutable functions vs. join for lookups ?
Date
Msg-id 42661878.6010802@familyhealth.com.au
Whole thread Raw
In response to Re: immutable functions vs. join for lookups ?  (Dawid Kuroczko <qnex42@gmail.com>)
List pgsql-performance
Tree view 
> Yay!  You're right!  I wonder why have I forgotten about LANGUAGE SQL. :)
> It's 30 seconds vs 5 seconds for CASE ... END insisde PLpgsql vs CASE...END
> LANGUAGE SQL. :)  I.e. its almost the same as in-place entered SQL.

Probably because simple SQL functions get inlined by the optimiser.

Chris

pgsql-performance by date:

Previous
From: Dawid Kuroczko
Date:
Subject: Re: immutable functions vs. join for lookups ?
Next
From: Dawid Kuroczko
Date:
Subject: Re: How to improve db performance with $7K?