Klaus Aschenbrenner
@sqlpassion.at
CEO & Founder of https://SQLpassion.at. SQL Server & PostgreSQL specialist during the day. Astrophotographer during the night. Triathlete in between. Loves low-level system programming in Rust.
Reposted by Klaus Aschenbrenner
Donald Trump hat dem Premierminister von Norwegen geschrieben, dass er sich Grönland nehmen wird, weil er den Friedensnobelpreis nicht bekommen hat und sich jetzt dem Frieden nicht mehr so verpflichtet fühlt.
Dann ist ja beruhigend, dass dieser besonnene, erwachsene Mann 6.000 Atomsprengköpfe hat.
Dann ist ja beruhigend, dass dieser besonnene, erwachsene Mann 6.000 Atomsprengköpfe hat.
January 19, 2026 at 10:18 AM
Donald Trump hat dem Premierminister von Norwegen geschrieben, dass er sich Grönland nehmen wird, weil er den Friedensnobelpreis nicht bekommen hat und sich jetzt dem Frieden nicht mehr so verpflichtet fühlt.
Dann ist ja beruhigend, dass dieser besonnene, erwachsene Mann 6.000 Atomsprengköpfe hat.
Dann ist ja beruhigend, dass dieser besonnene, erwachsene Mann 6.000 Atomsprengköpfe hat.
[Blog] BRIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #performance #PostgreSQL #postgres
BRIN Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 19, 2026 at 10:21 AM
[Blog] BRIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #performance #PostgreSQL #postgres
Reposted by Klaus Aschenbrenner
2024: can Europe defend itself ALONGSIDE America?
2025: can Europe defend itself WITHOUT America?
2026: can Europe defend itself AGAINST America?
2025: can Europe defend itself WITHOUT America?
2026: can Europe defend itself AGAINST America?
January 18, 2026 at 10:12 AM
2024: can Europe defend itself ALONGSIDE America?
2025: can Europe defend itself WITHOUT America?
2026: can Europe defend itself AGAINST America?
2025: can Europe defend itself WITHOUT America?
2026: can Europe defend itself AGAINST America?
MAGA : Make America Go Away…
there will prob be a global boycott of US goods by the end of his term
January 17, 2026 at 6:45 PM
MAGA : Make America Go Away…
Wise words! :-)
New blog post inspired by Robert Greene's timeless observations on change and our need to adapt (in the age of AI)
mathias.blog/posts/change...
mathias.blog/posts/change...
Change is the law, AI is the catalyst - Mathias Lafeldt
Change is inevitable. AI is accelerating it. Robert Greene said it best.
mathias.blog
January 15, 2026 at 4:56 PM
Wise words! :-)
If a SQL Server query is slow, it’s rarely random.
Most performance problems come from the same issue:
Execution plans that are misunderstood, misread, or ignored completely.
You add an index.
It helps - until it doesn’t.
Then you rewrite the query.
Then performance changes again.
Most performance problems come from the same issue:
Execution plans that are misunderstood, misread, or ignored completely.
You add an index.
It helps - until it doesn’t.
Then you rewrite the query.
Then performance changes again.
SQL Server Query Tuning Fundamentals – SQLpassion
www.SQLpassion.at
January 15, 2026 at 3:28 PM
If a SQL Server query is slow, it’s rarely random.
Most performance problems come from the same issue:
Execution plans that are misunderstood, misread, or ignored completely.
You add an index.
It helps - until it doesn’t.
Then you rewrite the query.
Then performance changes again.
Most performance problems come from the same issue:
Execution plans that are misunderstood, misread, or ignored completely.
You add an index.
It helps - until it doesn’t.
Then you rewrite the query.
Then performance changes again.
I really love the SSH Keys integration in @1password.bsky.social. The hardest part was the configuration across multiple client machines, so that the correct SSH key is handed out based on the machine that I'm currently using (Mac or Linux). The file agent.toml is here your friend :-)
January 15, 2026 at 3:08 PM
I really love the SSH Keys integration in @1password.bsky.social. The hardest part was the configuration across multiple client machines, so that the correct SSH key is handed out based on the machine that I'm currently using (Mac or Linux). The file agent.toml is here your friend :-)
Is here someone who works with #PostgreSQL at aiven.io?
Aiven - Your AI-ready Open Source Data Platform
Aiven is an AI-ready open source data platform that combines open-choice services to rapidly stream, store and serve data across major cloud providers — simply and securely.
aiven.io
January 14, 2026 at 7:48 PM
Is here someone who works with #PostgreSQL at aiven.io?
I’ve just published my 2nd #PostgreSQL Quickie:
PostgreSQL Quickie #2: Installation in Virtual Machines youtu.be/E-hDSoArqdI This is the 1st Quickie that I have entirely produced on Linux - even the editing (in DaVinci Resolve) and publishing.
Enjoy! 🙂
PostgreSQL Quickie #2: Installation in Virtual Machines youtu.be/E-hDSoArqdI This is the 1st Quickie that I have entirely produced on Linux - even the editing (in DaVinci Resolve) and publishing.
Enjoy! 🙂
PostgreSQL Quickie #2: Installation in Virtual Machines
YouTube video by SQLpassion
youtu.be
January 14, 2026 at 6:54 PM
I’ve just published my 2nd #PostgreSQL Quickie:
PostgreSQL Quickie #2: Installation in Virtual Machines youtu.be/E-hDSoArqdI This is the 1st Quickie that I have entirely produced on Linux - even the editing (in DaVinci Resolve) and publishing.
Enjoy! 🙂
PostgreSQL Quickie #2: Installation in Virtual Machines youtu.be/E-hDSoArqdI This is the 1st Quickie that I have entirely produced on Linux - even the editing (in DaVinci Resolve) and publishing.
Enjoy! 🙂
Deploying a Linux-based Virtual Machine from *scratch* in only 30 seconds - I really *love* the @exoscale.com cloud. Booting my physical Linux workstation even takes longer...
January 14, 2026 at 2:52 PM
Deploying a Linux-based Virtual Machine from *scratch* in only 30 seconds - I really *love* the @exoscale.com cloud. Booting my physical Linux workstation even takes longer...
Reposted by Klaus Aschenbrenner
Tuning your database just right can be counter-intuitive, unless you understand all levels of the system.
Intuitively, most would say "more work_mem = better" for building indexes, but this hurts performance due to L3 cache behavior.
Great article by Tomas Vondra.
vondra.me/posts/dont-g...
Intuitively, most would say "more work_mem = better" for building indexes, but this hurts performance due to L3 cache behavior.
Great article by Tomas Vondra.
vondra.me/posts/dont-g...
January 13, 2026 at 2:10 PM
Tuning your database just right can be counter-intuitive, unless you understand all levels of the system.
Intuitively, most would say "more work_mem = better" for building indexes, but this hurts performance due to L3 cache behavior.
Great article by Tomas Vondra.
vondra.me/posts/dont-g...
Intuitively, most would say "more work_mem = better" for building indexes, but this hurts performance due to L3 cache behavior.
Great article by Tomas Vondra.
vondra.me/posts/dont-g...
AI tools can be quite powerful, if you use them in the correct way :-) Reading and trying to understand the #PostgreSQL source code...
January 13, 2026 at 1:42 PM
AI tools can be quite powerful, if you use them in the correct way :-) Reading and trying to understand the #PostgreSQL source code...
Yesterday I’ve signed uo to the pgsql-hackers mailing list. OMG… information overflow 😁
January 13, 2026 at 11:55 AM
Yesterday I’ve signed uo to the pgsql-hackers mailing list. OMG… information overflow 😁
I really like it to use Claude Code to read/browse through the #PostgreSQL code base...
January 12, 2026 at 9:33 PM
I really like it to use Claude Code to read/browse through the #PostgreSQL code base...
[Blog] GIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL
GIN Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 12, 2026 at 12:57 PM
[Blog] GIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL
Reposted by Klaus Aschenbrenner
January 11, 2026 at 10:19 AM
Reposted by Klaus Aschenbrenner
It's fascinating to see the changes in one company's logo over the years.
January 3, 2026 at 2:47 AM
It's fascinating to see the changes in one company's logo over the years.
That time when you need 3 different LLMs to get a working physical memory manager in Rust, that runs on bare-metal hardware…
January 9, 2026 at 7:06 PM
That time when you need 3 different LLMs to get a working physical memory manager in Rust, that runs on bare-metal hardware…
Reposted by Klaus Aschenbrenner
Running AI in Europe? Your vectors should stay there too.
Exoscale DBaaS offers managed pgvector and vector search on opensearch in GDPR-compliant EU zones, built on open source with no lock-in.
www.exoscale.com/dbaas/vector...
.
.
.
#ai #vectordatabase #europeancloud #sovereigncloud
Exoscale DBaaS offers managed pgvector and vector search on opensearch in GDPR-compliant EU zones, built on open source with no lock-in.
www.exoscale.com/dbaas/vector...
.
.
.
#ai #vectordatabase #europeancloud #sovereigncloud
January 9, 2026 at 8:00 AM
Running AI in Europe? Your vectors should stay there too.
Exoscale DBaaS offers managed pgvector and vector search on opensearch in GDPR-compliant EU zones, built on open source with no lock-in.
www.exoscale.com/dbaas/vector...
.
.
.
#ai #vectordatabase #europeancloud #sovereigncloud
Exoscale DBaaS offers managed pgvector and vector search on opensearch in GDPR-compliant EU zones, built on open source with no lock-in.
www.exoscale.com/dbaas/vector...
.
.
.
#ai #vectordatabase #europeancloud #sovereigncloud
Running my bare-metal Rust Kernel on physical hardware: a Lenovo W510 notebook from the year 2010.
January 8, 2026 at 5:01 PM
Running my bare-metal Rust Kernel on physical hardware: a Lenovo W510 notebook from the year 2010.
These days we can life-watch the beginnings of Oceania, Eurasia, and Eastasia… 🤬😢
January 8, 2026 at 9:55 AM
These days we can life-watch the beginnings of Oceania, Eurasia, and Eastasia… 🤬😢
By migrating my OS to Rust, I have learned something new about Linux internals: how it handles terminal alternative buffers on the source code level: jameshfisher.com/2017/12/04/h...
How less works: the terminal's alternative buffer
`less` uses the terminal's "alternate screen" feature to clear the screen and display the contents of a file, and then restores the previous screen when exiting.
jameshfisher.com
January 7, 2026 at 7:58 PM
By migrating my OS to Rust, I have learned something new about Linux internals: how it handles terminal alternative buffers on the source code level: jameshfisher.com/2017/12/04/h...
Currently, I'm having some "fun" by migrating my C-based OS to #Rust with the help of a cool AI trio: GitHub CoPilot, OpenAI Codex, and Claude Code
January 7, 2026 at 7:18 PM
Currently, I'm having some "fun" by migrating my C-based OS to #Rust with the help of a cool AI trio: GitHub CoPilot, OpenAI Codex, and Claude Code