Content pfp
Content
@
0 reply
0 recast
2 reactions
Varun Srinivasan pfp
Varun Srinivasan
@v
Why doesn’t Postgres let you specify hints to the query planner?
0 reply
3 recasts
33 reactions
derek pfp
derek
@derek
You can with extensions: https://github.com/ossc-db/pg_hint_plan
0 reply
0 recast
4 reactions
christopher pfp
christopher
@christopher
still coming out of recovery from Oracle SQL and hints are triggering :(
0 reply
0 recast
2 reactions
✳️ nibnalin on daimo pfp
✳️ nibnalin on daimo
@nibnalin.eth
Materialized views seem to work great for me for giving hints: create successive views that narrow down in a way that uses your best index / query path.
1 reply
0 recast
1 reaction
vrypan |--o--| pfp
vrypan |--o--|
@vrypan.eth
That's a great idea for a new rdbms. 😀
0 reply
0 recast
1 reaction
Kiren Srinivasan pfp
Kiren Srinivasan
@kiren
You get better and better at estimating down the line, regardless of ORM! Would be cool to see this built into Postgres tho
0 reply
0 recast
1 reaction
Britt Kim pfp
Britt Kim
@brittkim.eth
I haven’t seen anything like that since old SQL server days.
0 reply
0 recast
1 reaction
Erdos pfp
Erdos
@savish
78 $WC
0 reply
0 recast
0 reaction
Agha Shah pfp
Agha Shah
@aghashah
Koch b
0 reply
0 recast
0 reaction
Alpha Cameroon pfp
Alpha Cameroon
@idohodl
To make the life miserable!
0 reply
0 recast
0 reaction
Fredy Warn pfp
Fredy Warn
@fredy
@v sir tip pls
0 reply
0 recast
0 reaction
Goatkeeper pfp
Goatkeeper
@goatkeeper
I don’t know bro
0 reply
0 recast
0 reaction
sevenic🎩 pfp
sevenic🎩
@sevenchen
Your talent shines bright
0 reply
0 recast
0 reaction
Munshi Khan pfp
Munshi Khan
@munshikhan
Please give me Degen🙏😢😢😥
0 reply
0 recast
0 reaction
Beyto pfp
Beyto
@beyto
🚀 Your cast cashed in! Claim 🎩 DEGEN tokens on jam now! 🟣 https://jam.so/?referrer=JTPh5v 🟣
0 reply
0 recast
0 reaction
purplezky 🎩 pfp
purplezky 🎩
@purplezky
https://dev.to/aws-heroes/postgresql-optimizer-hints-discussion-1nnm
0 reply
0 recast
0 reaction
JangKroed🎩 pfp
JangKroed🎩
@jangkroed
Isn't it mostly because of the security related to query injection?
0 reply
0 recast
0 reaction