Pinned
Vik Fearing
Vik Fearing
@vik.thegresqlpost.org
Member of the ISO/IEC working group for SQL. Performance is an implementation detail. Major Contributor to PostgreSQL. he/him by default but will happily answer to anything. ๐ณ๏ธโ๐ https://thegresqlpost.org/
274 followers126 following635 posts
Vik Fearing reposted
Apollo and Daphne, by Daniel Seiter, 1675-99, ๐ธ by @jeffreyphelps // @milwaukeebrewers.bsky.social
Vik Fearing reposted
Vik Fearing reposted
Tomorrow at PGConf.EU in Valencia, Petr Jelinek and I are giving our first talk together! ๐ โPostgres for Everything, Until It Isn'tโ When should you stick with Postgres, and when is it worth adding another engine? ๐ 11:15 ยท Audit 1 www.postgresql.eu/events/pgcon...
A chart going from 100 down to zero but labeled โrelativeโ is just manipulative bullshit. Show real numbers or gtfo.
Since UKIP & the Brexit Party, Nigel Farage has relied on Russian bots to amplify social media support, but, oh dear ... "Reform UK supporting accounts have almost gone silent after Ukraine hit a few of Russiaโs big data centres" via Karen Maunder
Vik Fearing reposted
"SQLDoom ports the original 1993 Doom's game logic and renderer to SQL and runs it inside CedarDB." GitHub: https://github.com/cedardb/sqldoom
Vik Fearing reposted
Domain 1 of the Open Alliance for #PostgreSQL Education DBA-1 certification explained! All 14 exam topics in one video: how Postgres gets installed, where it lives on disk, how it's configured and secured, and how it's run and upgraded youtu.be/iIyFH8HSZEA
The industry keeps asking for index hints in the SQL standard. Codd named indexing dependence as a defect to be cured, in 1970, in the paper that introduced the relational model. A hint puts it back. thegresqlpost.org/articles/a-h... #PostgreSQL #SQL #Databases #datasky
Vik Fearing reposted
I just had a crazy thought, so I looked it up and of course it exists and has a name. I will have to check out those "in fiction" references. en.wikipedia.org/wiki/Rogue_p...
Vik Fearing reposted
Not reading this because a) it is obviously written by AI, and b) the first sentence here is just plain wrong.
Alexander Ioffe: Postgres runs your query fast exactly five times. Then it changes its mind. One prepared statement, twelve EXPLAIN ANALYZE runs on one connection, a plan change on run six, and why a single run could never have shown it. https://postgr.es/p/9uD #postgresql
Haha. Oracle copying Postgres again. cc @samokhvalov.bsky.social
Want to see what happens when you run a query in Oracle AI Database? @ora600pl.bsky.social has built OraCity - a visualisation of the process as a 3D city Follow the steps the query goes through from parsing, to planning, to running through its plan buff.ly/8Hfog2x
My car does not have an off button and I frikken hate it. Itโs the first thing on my list for a new car now.
Sean Duffy: "You know the stop/start button on your car? I hate that thing. Thank you Lee Zeldin! He's gotten rid of it and the first cars without the stop/start button are rolling off the line."
Vik Fearing reposted
News: PostgreSQL 18.6, 17.11, 16.15, 15.19, 14.24 and 19 Beta 3 Released! https://www.postgresql.org/about/news/postgresql-186-1711-1615-1519-1424-and-19-beta-3-released-3365/ #postgresql
Venn diagrams for teaching relational joins are plain wrong. I explain why in this new article. thegresqlpost.org/articles/joi...
Vik Fearing reposted