Conversation

Notices

1. Embed this notice
   Tek say resist (tek@freeradical.zone)'s status on Tuesday, 17-Dec-2024 22:16:25 JST Tek say resist

   in reply to

   • tuban_muzuru
   • doskel

   @tuban_muzuru @doskel It gets crazier: https://heterodb.github.io/pg-strom/

   • Embed this notice
     tuban_muzuru (tuban_muzuru@ohai.social)'s status on Tuesday, 17-Dec-2024 22:16:26 JST tuban_muzuru

     in reply to

     • doskel

     @doskel

     Improved Query Planner:

     Just-in-Time (JIT) Compilation:

     PostgreSQL can now compile parts of queries into machine code at runtime, which can significantly speed up execution, especially for complex queries and analytical workloads.

   • Embed this notice
     doskel (doskel@masto.doskel.net)'s status on Tuesday, 17-Dec-2024 22:16:27 JST doskel

     in reply to

     after spending a whole thirty seconds making an index for the text field, i can now search for literally anything and get my results in like half a second

     this shit has got to be harnessing like, the dark arts

   • Embed this notice
     doskel (doskel@masto.doskel.net)'s status on Tuesday, 17-Dec-2024 22:16:34 JST doskel

     in reply to

     HOW DID THEY DO THIS

   • Embed this notice
     doskel (doskel@masto.doskel.net)'s status on Tuesday, 17-Dec-2024 22:16:34 JST doskel

     in reply to

     i just full text searched the entire post database (WITHOUT ANY INDEXING) for "what the everloving fuck" and got back my results in ~20s
     HOW
     THERE ARE LIKE 2 MILLION POSTS IN THIS DATABASE

   • Embed this notice
     doskel (doskel@masto.doskel.net)'s status on Tuesday, 17-Dec-2024 22:16:35 JST doskel

     postgres fucking scares me
     you can have a table with like, a billion rows, and with an indexed bigint column, it'll find any row you ask basically instantly
     it's fucking magic