News for hackers. Stuff that matters.

A comment on Look ma, I wrote a new JIT compiler for PostgreSQL. Parent comment

Re:Look ma, I wrote a new JIT compiler for PostgreSQL by SigmundA on Monday March 18, 2024 @11:18AM (#39745726)
Is x a parameter because it doesn't look like it? MSSQL has parameter sniffing and will make multiple plans based on incoming parameters I would be surprised if Oracle does not do the same. It can actually be problematic to sniff parameters sometimes and it can be disabled with a hint!
[ Parent | on HN ]
Re:Look ma, I wrote a new JIT compiler for PostgreSQL by aeyes on Monday March 18, 2024 @11:41AM (#39746041)
I just made up something simple but yes, I had these problems with bind variables in prepared statements.

> SELECT * FROM t WHERE x = :var;

But I haven't used Oracle in years and back in the day, there was no bind variable peeking.

[ Parent | on HN ]