Franck Pachot(@FranckPachot) 's Twitter Profileg
Franck Pachot

@FranckPachot

🐘 #OpenSource #Distributed #PostgreSQL
🥑 Developer Advocate @Yugabyte​DB ▝▞
🔸 AWS Data Hero
🅾️ Oracle Certified Master
 maybe 𝕏posting to bsky/mstdn/lnkdn

ID:866752441

linkhttp://blog.pachot.net calendar_today07-10-2012 18:28:56

34,1K Tweets

13,7K Followers

1,6K Following

Follow People
Franck Pachot(@FranckPachot) 's Twitter Profile Photo

15 minutes ago I learned about Slick (Scala ORM) and tested a Scala program for the first time
👉 I recommend not using InsertOrUpdate or you will lose transactions
github.com/slick/slick/is…

account_circle
Franck Pachot(@FranckPachot) 's Twitter Profile Photo

Playing with dbtune.ai 😎
Let's show PostgreSQL's paradox: 📉best response time with 📉lower memory usage and 📈more IOs
💡Do you know why?
.
.
.
👉no direct IO requires a lot of available RAM
👉 those IOPS are filesystem cache hits - see 100% CPU usage (it's mostly system CPU)

Playing with @dbtuneai 😎 Let's show @PostgreSQL's paradox: 📉best response time with 📉lower memory usage and 📈more IOs 💡Do you know why? . . . 👉no direct IO requires a lot of available RAM 👉 those IOPS are filesystem cache hits - see 100% CPU usage (it's mostly system CPU)
account_circle
Marc Brooker(@MarcJBrooker) 's Twitter Profile Photo

New blog post, on the 'you don't need distributed systems' meme, and the idea that distributed systems are only about scale: brooker.co.za/blog/2024/06/0… Short version: scale is only a tiny part of what makes distributed systems interesting and useful.

account_circle
VoxxedDaysLuxembourg(@voxxed_lu) 's Twitter Profile Photo

Franck Pachot (Franck Pachot) viendra nous parler d'indexation SQL avancée à Voxxed Days Luxembourg 2024 les 20 et 21 juin prochains.

mobile.devoxx.com/events/voxxedl…

Franck Pachot (@FranckPachot) viendra nous parler d'indexation SQL avancée à Voxxed Days Luxembourg 2024 les 20 et 21 juin prochains. mobile.devoxx.com/events/voxxedl… #voxxed_lu #speakers
account_circle
Franck Pachot(@FranckPachot) 's Twitter Profile Photo

Yes there are databases which are resilient to failure: transactions continue rather than being canceled to retry after failover.
That's how YugabyteDB works

account_circle
Franck Pachot(@FranckPachot) 's Twitter Profile Photo

Thanks JCON organizers for publishing the recordings. Not all folks can travel to conferences, great to have the content online.
I'm there on Twitter for any questions or feedback 🙂

account_circle
YugabyteDB(@Yugabyte) 's Twitter Profile Photo

Don't miss our upcoming webinar with ValStream Head of Development, Thomas Thurston, who will share how is building a , procurement solution with .

📆 June 18th - 9am PDT 📆

Register now!⬇️
hubs.la/Q02zC4Rb0

Don't miss our upcoming webinar with ValStream Head of Development, Thomas Thurston, who will share how #ValStream is building a #scalable, #resilient procurement #SaaS solution with #YugabyteDB. 📆 June 18th - 9am PDT 📆 Register now!⬇️ hubs.la/Q02zC4Rb0
account_circle
Kamil Stawiarski(@ora600pl) 's Twitter Profile Photo

Funny story - on ARM kcbklbc is being executed on a commit and on x86 - each time I modify a block 🤪
Anyone can explain this?

account_circle
Franck Pachot(@FranckPachot) 's Twitter Profile Photo

A tip from Stefan Fercot about incremental backups in PostgreSQL: take an incremental backup just after the full one to reduce recovery time. This practice is applicable in Oracle Database, but I've not seen it commonly applied. What about you?

account_circle
Franck Pachot(@FranckPachot) 's Twitter Profile Photo

Great article by Arisa Izuno explaining the data modeling considerations for Distributed SQL, using an example from the PostgreSQL tutorial and optimizing it for YugabyteDB​DB 🤓🤩yugabyte.com/blog/postgresq…

account_circle