Search Postgresql Archives

Re: Tricking the optimizer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux