News for hackers. Stuff that matters.

A comment on Introducing “Database Performance at Scale”: A Free, Open Source Book. Parent comment

Re:Introducing “Database Performance at Scale”: A Free, Open... by mr_toad on Thursday October 05, 2023 @10:39PM (#37786637)
What’s really bad is where they (or the ORM) generate a seperate select statement for each ID in a loop.
[ Parent | on HN ]
Re:Introducing “Database Performance at Scale”: A Free, Open... by sgarland on Friday October 06, 2023 @07:14PM (#37797523)
And this doesn’t even get into bizarre edge cases, like how Postgres treats foo = ANY(ARRAY[‘bar’, ‘baz’]) differently than foo IN (VALUES((‘bar’), (‘baz’))). PROTIP: the latter is often MUCH faster. I’ve learned this twice this week.
[ Parent | on HN ]