
Tanel Poder ๐บ๐ฆ
@TanelPoder
Creator of http://0x.tools and a long time computer performance nerd. Performance & Troubleshooting Training: https://learn.tanelpoder.com
๋ด๊ฐ ์ข์ํ ๋งํ ์ฝํ ์ธ
pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL tanelpoder.com/posts/generateโฆ

My man @TanelPoder continues his quest to Make Observability Great Again! tanelpoder.com/posts/optimiziโฆ
Join us tomorrow at 9am PT for a livestream covering how to migrate your Postgres database to PlanetScale. We'll go over different migration methods like dump/restore, logical replication, and Amazon DMS + a live Q&A. Watch live on X or register here: streamyard.com/watch/h64fznWKโฆ
Sql people scare me
pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL tanelpoder.com/posts/generateโฆ

pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL tanelpoder.com/posts/generateโฆ

OMG lol
Instrumentation is investment! (when the topic of instrumentation overhead comes up)
This is your chance to shape what products we build, how we build them, and what features they should have ... Take the Oracle DB Developer Survey 2025 and share your insights: customersurveys.oracle.com/ords/surveys/tโฆ
A little sample of the xtop tool that I'll be demoing soon! ๐

eBPF has always been a popular topic at #P99CONF. On October 22-23, we'll welcome @TanelPoder, @DDelnano, Jake Hillion, and @parttimen3rd to share what's next for observability and #eBPF. Don't miss these interactive sessions! ow.ly/NpUk50WRh65 #ScyllaDB

eBPF has always been a popular topic at #P99CONF. On October 22-23, we'll welcome @TanelPoder, @DDelnano, Jake Hillion, and @parttimen3rd to share what's next for observability and #eBPF. Don't miss these interactive sessions! ow.ly/NpUk50WRh65 #ScyllaDB

#PostgresMarathon 2-004: Fast-path locks explained (and the PG 18 improvement) ๐ don't forget to subscribe & share! we'll be diving into various dark corners of Postgres and learn how to make it ludicrously fast ๐ After 2-003, @ninjouz asked: > If fast-path locks are storedโฆ



Today's video is a SQL tip! Are you seeing the ORA-00918 error at random times? Here is the likely cause, and just like in most cases, it all comes back to same reason as always :-) youtu.be/VErx5k-H4J8
youtube.com
YouTube
Why you are getting "ORA-00918: column ambiguously defined"
eBPF is like a runtime-programmable OS running within your OS. The tracing, security, network data path ops tools are just some types of apps built on top of that programmable OS (with x-ray vision to everything that's going on).
๐ Your Weekend Read: @P99CONF is the premier place to learn how engineers are pushing eBPF to its limits. We look back and preview upcoming talks from @jrfernandez, Liz Rice, @tanelpoder, @andy_pavlo, @parttimen3rd, & @ddelnano. ow.ly/ncjn50X64zy #ScyllaDB #P99CONF
๐ Your Weekend Read: @P99CONF is the premier place to learn how engineers are pushing eBPF to its limits. We look back and preview upcoming talks from @jrfernandez, Liz Rice, @tanelpoder, @andy_pavlo, @parttimen3rd, & @ddelnano. ow.ly/ncjn50X64zy #ScyllaDB #P99CONF
Fun fact, the original websocket drafts didnโt have these control frames in spec, which is why the socket.io protocol has its own ping/pong mechanism
WebSocket has their own Keep Alive mechanisms just like TCP, and it is called PING , PONG. The main reason is to keep the connection alive, check if the other peer is still connected and I think you can send data inline as part of the PING or PONG (never tried it though).โฆ

Andy Pavloโs take on mmap() in databases is controversial, but correct. Buffer pool management, and managing the contents of caches, is a core competency of a database system. The heuristics that an OS kernel uses for this are highly unlikely to be the right ones for a DB.
This just says they are changing the API, not removing the functionality. I am not against all applications using MMAP. I am against database systems using it instead of implementing a buffer pool manager.
eBPF can be used for latency analysis, high performance networking, noisy neighbor detection, & K8s observability. We look at past and upcoming #P99CONF sessions from @jrfernandez, Liz Rice, @tanelpoder, @andy_pavlo, @parttimen3rd, & @ddelnano. ow.ly/opzi50X52qY #ScyllaDB
Oracle Flashback Database can apparently auto-disable itself on I/O errors. I did a few quick test cases about it as I didn't expect this behavior initially. You can read about my findings here: blog.srecnik.info/oracle-flashbaโฆ
PostgreSQL 18 rc1: Stamp 18.0 git.postgresql.org/gitweb/?p=postโฆ
United States ํธ๋ ๋
- 1. #DWTS 14.4K posts
- 2. Robert 98.7K posts
- 3. #RHOSLC 2,836 posts
- 4. #WWENXT 9,058 posts
- 5. Elaine 39.3K posts
- 6. Whitney 12.3K posts
- 7. Carrie Ann 1,252 posts
- 8. #DWCS 1,875 posts
- 9. Young Republicans 39.8K posts
- 10. DโAngelo 385K posts
- 11. Politico 240K posts
- 12. Jackson Chourio 1,725 posts
- 13. Charlie 743K posts
- 14. #LHHATL N/A
- 15. Dennis Quaid 1,629 posts
- 16. Erika Kirk 97.4K posts
- 17. Teoscar 2,840 posts
- 18. Angie 68.1K posts
- 19. Matt Cardona 1,404 posts
- 20. Cornelia 1,628 posts
๋ด๊ฐ ์ข์ํ ๋งํ ์ฝํ ์ธ
-
Ask TOM for Database/SQL
@OracleAskTOM -
Jonathan Lewis
@JLOracle -
Franck Pachot
@FranckPachot -
Connor on SQL and Database
@connor_mc_d -
Mike Dietrich
@MikeDietrichDE -
Maria Colgan
@SQLMaria -
Frits Hoogland
@fritshoogland -
Martin Bach
@MartinDBA -
Tim Hall โ๐ต+โโจ๏ธ
@oraclebase -
Oren Nakdimon
@DBoriented -
Ludovico Caldara
@ludodba -
Markus Michalewicz
@KnownAsMarkus -
ORA-600
@POUG_ORG -
SQL.ProductManager.Oracle.Databases
@thatjeffsmith -
Pete Finnigan
@petefinnigan
Something went wrong.
Something went wrong.