Re: Order of execution

[Jean-Christophe Boggio <postgresql@xxxxxxxxxxxxxx>]

Hello,

Le 27/04/2021 à 20:52, luis.roberto@xxxxxxxxxxxxxxx a écrit :
> My question is: is it possible to optimize function order execution?

I guess you could change the cost of one of the functions.


I personally rewrite my queries but I don't know if it's good practice:

WITH pre AS (
  SELECT client_id
  FROM clients
  WHERE some_other_func(client_id)
)
SELECT *
FROM clients
JOIN pre USING(client_id)
WHERE some_func(client_id)

Best regards,

JC