Re: Tricking the optimizer - Mailing list pgsql-general

From Vitaliy Garnashevich
Subject Re: Tricking the optimizer
Date
Msg-id 2a11d6ec-837e-5284-38cf-efedc52dbbd2@gmail.com
Whole thread Raw
In response to Re: Tricking the optimizer  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Tricking the optimizer  (Vitaliy Garnashevich <vgarnashevich@gmail.com>)
List pgsql-general
We'd rather avoid writing C code. We're trying to stick with the DB 
functionality provided by default.

Could something like the following, in theory, make things at least 
somewhat better in our case (without using the selectivity override)?

... WHERE coalesce(securityFilter1 AND securityFilter2 AND 
securityFilter3)::bool;

Regards,
Vitaliy



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade: when the --old-bindir requires "additional" $libdir/plugins?
Next
From: greigwise
Date:
Subject: postgres on physical replica crashes