Gregory Smith @postgresperf
#PostgreSQL engineer for @Snowflake @crunchydata, database and audio author. Family advocate for #MyalgicEncephalomyelitis #POTS #PwME #MEcfs patients. Baltimore, MD Joined September 2011-
Tweets233
-
Followers460
-
Following94
-
Likes84
@craigkerstiens @willking Been doing this too long, I read the code and can see the picture in my head. The (-2.2,-1.5) is a dead giveaway. I first did this in BASIC to a dot matrix printer in 1985, still have that here.
@mdonnino @sunsopeningband Severe PEM patients can't, that's the criteria problem. Their best day is a paced hour to eat and use the bathroom. 2 hour burst session? That means starving then 14 days of PEM 8+ pain. Their energy problems are serious, obvious. The easy remissions you're seeing don't happen.
@AbyssPearl It's tough, even on this post you only got a few responses before the ignorant "challenge yourself!" trolls showed up.
Nov 20 is our annual PostGIS day, check it out, and my state of PG18 report is over on LinkedIn. tl;dr Postgres 18 loads the whole OSM Planet set 3% faster than PG17 due to adding parallel GIN index builds, which are 3X as fast. linkedin.com/pulse/postgis-…
Ran into this on my benchmark data set! Canceled a query that had already run for two days, found this plan: Nested Loop (cost=78,613,867,046.43 rows=20,718,100 width=1144) Oopsie! Add missing index, 6 minutes: Nested Loop (cost= 1,881,853,963.95 rows=495,950 width=1144)
Postgres performance best practice: index all foreign keys. Primary keys are automatically indexed but if you reference a primary key in another table using a foreign key, that is not automatically indexed - and an index needs to be added manually.
NVIDIA's DGX Spark is based on Ubuntu 24.04, and the available package set include PostgreSQL 16.10. Just tried it out and the database worked fine on a quick spot check. pgbench tests rated initial performance as similar to M1 or M2 cores. Turing...err, Tuning time!
Gone Encyclopedia Brown and the mystery of why the Postgres server benched at 5Gbps over the 10G network. The physical x16 slot the NIC was plugged into, ha ha! Only runs at x1, so exactly 5Gbps. Only working 10G config is NIC in the GPU slot, against recommendation! Madness.
@ubuntu Great software engineers take on the hard jobs nobody wants, instead of just doing the easy, shiny work everyone else is chasing.
@BradenLockwood1 Core would need to merge a major new storage engine with features like columnar. We built an Iceberg storage engine to get good TPC-H/DS results. The gap is financial. Analytics code is valuable; releasing for free then funding an expensive core merge costs money.
@useless_priest I think of ME and OI a pair of bad feedback loops that are coupled together. In the example you're using, you might label that as a root cause the OI triggered first. Once you're out of the stable zone and into feedback squeal, you can't cleanly separate them anymore.
@sunsopeningband The thing about cherry-picking data is that people really love that home made cherry taste. Comprehensive data sets are all watered down and taste of p-values, yuck!
@DafoeWhitney Love how this picture lets me see your large tube headphone amps! I have a giant for the time amp from the Headroom brand I still use. This is me reviewing it then, and one of these days I am going to try out some of your headphones with it: soundstageaccess.com/equipment/head…
@sunsopeningband Now there's an ad campaign: "Naloxone: we could have saved Layne Staley"
Enjoyed this Crunchy history piece. Database engineering feels contrarian, still Moving Slow & Fixing Things. I enjoy how PostgreSQL grinds feature and extension at a time until it's right. Crunchy embraced that and danced past all the fork pitfalls. bigdatawire.com/2025/06/04/why…
@DafoeWhitney My early 90's audio included a lot of speaker testing with a Proton D1200, used to see that push 500W into 4 ohm Magnepan panels or big 8 ohm Klipsch designs. That VU user interface remains a marvel, and I wish we had something like it on everything.
Auto analogy time! Perl and Python are Swiss Army knife software tools, but those are just small embedded components to PG. PostgreSQL is more like a giant automotive shop toolbox where you just add more sections as you target additional car lines, like this Snap-On product:
I always thought I appreciated the unix philosophy of small sharp tools. Just now realized Postgres is not a small sharp tool it's a swiss army knife, now I'm contemplating all the rest of things I thought I believed in life.
Craig Kerstiens @craigkerstiens
10K Followers 890 Following Leading Postgres for @Snowflake. I blog at https://t.co/K49pnYYXpL. Previously CPO @crunchydata and before that @Microsoft, @citusdata, @Heroku, Truviso
Pavlo Golub @PavloGolub
2K Followers 406 Following PostgreSQL expert @PostgresSupport. Programmer. Engineer. 🇺🇦 https://t.co/2tSLn4Jju2Devrim Gündüz @DevrimGunduz
4K Followers 311 Following Works at @EDBPostgres, runs @GITCPro. Open source geek, PostgreSQL major contributor, RPM packager, F1 fan, and daddy. Türkçe: @DevrimGunduzTR
Paul Ramsey @pwramsey
7K Followers 226 Following Please find me at @[email protected] @pwramsey.bsky.social
Douglas J Hunley @hun... @hunleyd
468 Followers 182 Following Also known as: @[email protected] Linux Sys Admin, Gentoo user, PostgreSQL advocate, Android fanboi, OSS supporter, PlayStation gamer. Founder of @pgcmh.
Mike Freedman @michaelfreedman
7K Followers 409 Following Co-founder/CTO, @TigerDatabase / @TimescaleDB 🐯🦄. Professor, @PrincetonCS. Distributed systems, databases, AI, security, networking.
Bertrand Drouvot @BertrandDrouvot
2K Followers 617 Following Databases (mainly #PostgreSQL) stuff 🐘 - #PostgreSQL Major Contributor - @awscloud & all opinions are mine. 👉 https://t.co/cPag5SjXzc - @SLUCbasketNancy 🏀
kolektiva dot social ... @davidfetter
1K Followers 2K Following Parent, Abolitionist, World-wide presos, PostgreSQL Expert, jq & vim fan, he/him 🍉✡🔻 No employer has hired me to speak for them through this account, or willJeremy Schneider @jer_s
2K Followers 415 Following Building and running reliable data platforms that scale and perform. An organizer of Seattle Postgres User Group. My opinions are my own.
Thomas Munro @MengTangmu
2K Followers 368 Following PostgreSQL and sometimes FreeBSD hacker. https://t.co/xNzXgIYxiF, tmunro on libera
Masahiko Sawada @masahiko_sawada
3K Followers 1K Following PostgreSQL Major Contributor & Committer.
Crunchy Data @crunchydata
8K Followers 2K Following Fully managed, hosted Postgres on AWS, GCP, and Azure.
Dan Langille @dvl@bsd... @DLangille
3K Followers 515 Following Mountain biker. Dev turned sysadmin. Websites & databases. Conference organizer. Practical examples are best. Pizza. Beer. Movies. (he/him)
hydrobiont @the_hydrobiont
419 Followers 224 Following
Peter van Hardenberg @pvh
5K Followers 1K Following Ink & Switch lab director. Heroku alum. I don't come here anymore. Masto: @[email protected] BSky: @pvh.ca
Jaime Casanova @JCasanovaEC
671 Followers 412 Following Director de Servicios Profesionales en SystemGuards. Experto en PostgreSQL. Miembro del PGDG.
Elizabeth Garrett Chr... @sqlliz
691 Followers 848 Following Doing fun things with Postgres @snowflake via @crunchydata. Married to @pg_dwc.
Magnus Hagander @magnushagander
3K Followers 363 Following opensource advocate. @postgresql core team, committer, infrastructure team, board of @postgresqleu, sailor. working at https://t.co/hA9OMICq8n
goth egg @gotheggn
8 Followers 73 Following Am here looking for a willing man to share my sweet moments with me🥰🥰🥰
Gloria @Glorial8of
0 Followers 8 Following
Tiffany smith @Tiffany_0009
53 Followers 2K Following
liuzhilong62 @liuzhilong62
1 Followers 163 Following Postgres 爱好者, 也是一个DBA。 微信公众号:最后的DBA csdn:https://t.co/TNUiRbyyrU 墨天轮:https://t.co/IX1GeSHXiU
César Carvalho @Cesar_DBA
305 Followers 1K Following Christian. Oracle ACE Pro ♠ @oracleace🅾️, DBA, OCP, RAC, Data Guard, MCSE, MCSA SQL Server. #OracleACE #Database #Linux
Keith Ward @ThoughtEng
5 Followers 20 Following Engineering insights on debugging, infra, performance. Basically my work diary.
Shena Woodard @shenawokdard
41 Followers 1K Following mother of one daughter, I'm 45, looking for a true love ❤️ I'm new on this website
Charlotte Sandra @HarrySarah88156
892 Followers 3K Following
Muhammad Azeez @mhmd_azeez
1K Followers 2K Following Software Engineer. C#, Go, and JS. Working on AI Agents, Workflows, and MCP
shadow dev @JohnCodalot
20 Followers 780 Following he/him software engineer building cool stuff by night, shadow the hedgehog fan account 25yo
Alexandre Araujo @ale_araujo16
31 Followers 409 Following
Catdonnieee @catdonnieee
280 Followers 7K Following
Savanamaga @savanamagaB
4 Followers 573 Following I will never say things I do not know about..American was amazing👌God Blessed American🇱🇷 Never stop learning🧏 will live to learn & forgive when needed ✍️📌
Mineaki Motohashi @mmotohas
3K Followers 354 Following 日本にSnowflakeを持ち込んだ人。SnowflakeのConsulting Manager、テクノロジーエバンジェリスト。 Oracle→Accenture→True Data CTO→Sigmaxyz→Snowflake。趣味はボウリング、サウナ。Tweets are my own.
geoff brown @geoffbr85790890
194 Followers 905 Following 1988 m.e /fm/MCS/CMV/toxoplasmosis/Grover's disease/ severe pain and it's still the same in 2024
Lilian @Lilianqueen33
161 Followers 4K Following Crypto Trader & Analyst I BTC & ETH Enthusiast l Daily insights
bhavani-DBA @bhavanidba
237 Followers 1K Following
Raymond Kemonde @RaymondKemonde
559 Followers 3K Following Techie, Avid-reader, Writer, Witty and Leader. #stablegenius DBA ~ Databases, Servers, Storage.
Sylwester Lachiewicz @slachiewicz
278 Followers 5K Following
geoslice @geoslice
302 Followers 5K Following
Mike Fridman @_mfridman
732 Followers 1K Following technology, landmarks, left joins and Go vibes. Protocol Buffers for the rest of us @bufbuild
jaydub @jonwarnick
161 Followers 1K Following EU is preparing war to distract from economic collapse. "Never go to sea with two chronometers; take one or three." src/util.cpp
Emil Stolarsky @EmilStolarsky
963 Followers 4K Following Trying to get computers to stop bullying me. Co-chair of SREcon19 EMEA, SREcon20 Americas West. Formerly @DigitalOcean, @Shopify. He/him
Frank Asimov @XFrankAsimov
89 Followers 2K Following C & Go & Zig & Elixir & Solidity Dev. Crypto & AI & Robotics Builder. https://t.co/nNlmCxPxhe
12345 @simping4eggman
0 Followers 8 Following I do chaos magick under the premise of ios development
Joan U.S.minsky 💯�... @JuanLluesma
791 Followers 1K Following #parlavalencià #portugaldelest #regnicoles #vcf #limout #postgres #padel #etseuv #armossar forasters=nacionalmadridisme=nacionalbarcelonisme
Totiseau @TotiseauugUo
55 Followers 2K Following
Jennifer McCallister @Jeff58159Sharon
11 Followers 297 Following
Renegade Research @RenegadeRes
3K Followers 3K Following Patient-led 501(c)(3) nonprofit working on #MECFS & #LongCovid💙 Runs project @remissionbiome • https://t.co/W0iQqqSYY2
BMCservers @ServersBMC
1K Followers 5K Following BMC servers came into existence to help clients, customers and the entire hosting community to grow by taking advantage of the best available hosting deals.
Quentin de Metz @quentindemetz
19 Followers 20 Following
wormhole1026 @wormhole1026
6 Followers 406 Following
Michael J Weirsky @JWeirsky13
128 Followers 5K Following MEGA MILLIONS JACKPOT WINNER I’M MICHAEL J WEIRSKY WINNER OF $273,000.00 GIVING AWAY $50,000.00 TO MY FIRST 2,000.00 FOLLOWERS BE A LIVE WINNER TODAY
Marius Mierloiu @mierloiu_
77 Followers 2K Following
Christian Humer @grashalm_
2K Followers 460 Following PL/VM/Compilers at Oracle. Working on Truffle/Graal. ME/CFS Caretaker and Activist (https://t.co/gWxW16A5Op). Austrian expat in Zurich. https://t.co/piKOfYIYCL
Leah Zamora Johnson @leah_johns93820
54 Followers 2K Following
Mohammed Rai @MohammedRai79
4 Followers 224 Following
Juha Juutinen @juhajuutinen
89 Followers 2K Following Solution Architect / SW Engineer | Cloud, Backend, Linux, Android | Kotlin, Python, Rust
Paul Friedrich Schulz @fritzpaulcom
72 Followers 954 Following
Nik Samokhvalov @samokhvalov
12K Followers 44 Following Self-driving Postgres @postgres_ai // @PostgresFM // I stand with Ukraine
Craig Kerstiens @craigkerstiens
10K Followers 890 Following Leading Postgres for @Snowflake. I blog at https://t.co/K49pnYYXpL. Previously CPO @crunchydata and before that @Microsoft, @citusdata, @Heroku, Truviso
Planet PostgreSQL @planetpostgres
44K Followers 1 Following Blog entries from members of the PostgreSQL community
xzilla @ pgtreats @robtreat2
1K Followers 39 Following I help people Postgres. I enjoy root beer & road trips. My favorite colour is Amber. #WebOps #DBRE #pgtreats #🥑Devrim Gündüz @DevrimGunduz
4K Followers 311 Following Works at @EDBPostgres, runs @GITCPro. Open source geek, PostgreSQL major contributor, RPM packager, F1 fan, and daddy. Türkçe: @DevrimGunduzTR
Paul Ramsey @pwramsey
7K Followers 226 Following Please find me at @[email protected] @pwramsey.bsky.social
kolektiva dot social ... @davidfetter
1K Followers 2K Following Parent, Abolitionist, World-wide presos, PostgreSQL Expert, jq & vim fan, he/him 🍉✡🔻 No employer has hired me to speak for them through this account, or will
PostgreSQL @PostgreSQL
57K Followers 1 Following PostgreSQL - The world's most advanced Open Source Database
Thomas Munro @MengTangmu
2K Followers 368 Following PostgreSQL and sometimes FreeBSD hacker. https://t.co/xNzXgIYxiF, tmunro on libera
Crunchy Data @crunchydata
8K Followers 2K Following Fully managed, hosted Postgres on AWS, GCP, and Azure.
Devrim Gündüz @DevrimGunduzTR
6K Followers 273 Following @DevrimGunduz'ün Türkçe hesabı. PostgreSQL Major Contributor ve DJ. Çok gezgin. PostgreSQL Londra ve Türkiye milletvekili. Linux. Atatürk. Müzik. Güneş,Arp.
Peter van Hardenberg @pvh
5K Followers 1K Following Ink & Switch lab director. Heroku alum. I don't come here anymore. Masto: @[email protected] BSky: @pvh.ca
PostgreSQL Conference... @PGCon
4K Followers 0 Following PGCon is the place to meet, discuss, build relationships, learn valuable insights, and generally chat about the work you are doing with PostgreSQL
Elizabeth Garrett Chr... @sqlliz
691 Followers 848 Following Doing fun things with Postgres @snowflake via @crunchydata. Married to @pg_dwc.
Fujii Masao @fujii_masao
2K Followers 251 Following PostgreSQL committer, Database Engineer, maybe good husband & father.
Magnus Hagander @magnushagander
3K Followers 363 Following opensource advocate. @postgresql core team, committer, infrastructure team, board of @postgresqleu, sailor. working at https://t.co/hA9OMICq8n
Michael R Scoma MD @DrMichaelScoma
9K Followers 120 Following Infectious Disease Immunology physician specializing in complex chronic diseases. Views are my own; no medical advice given. https://t.co/HkQt5xRhlP
Christian Humer @grashalm_
2K Followers 460 Following PL/VM/Compilers at Oracle. Working on Truffle/Graal. ME/CFS Caretaker and Activist (https://t.co/gWxW16A5Op). Austrian expat in Zurich. https://t.co/piKOfYIYCL
W. Curtis Preston (Mr... @wcpreston
7K Followers 4K Following Backup & Recovery Expert since 1993. Known as Mr. Backup. Author of O'Reilly's Modern Data Protection, and Backup & Recovery.
StorageReview.com @storagereview
14K Followers 249 Following Enterprise infrastructure since 1998. Storage, servers, networking, AI. Independent reviews, lab benchmarks, breaking news from the data center.
Ray Lucchesi @RayLucchesi
5K Followers 87 Following Storage crazy for over 35 years https://t.co/eR5vO8beEj, Blog: https://t.co/sYIHvCxBts & Podcast: https://t.co/5vtbZD6WV3 https://t.co/mruq9sQorQ
Michael Moran | APC I... @internetuserf12
9K Followers 489 Following Doctorally trained herbalist and acupuncturist; Integrative oncology; Author; Researching APC dysfunction in chronic illness; Long Covid since 2020
onder kalaci @onderkalaci
174 Followers 519 Following
Average Database CEO @AvgDatabaseCEO
6K Followers 267 Following CEO of AvgDB. $100m series B. Now doing Auth and Storage!
Velu Erwan @erwanaliasr1
1K Followers 522 Following Opensource enthusiast & contributor, interested in low-level and performance. Kernel Recipes & PremDay founder, general #teamkrampouz. Beekeeper in free time.
Jens Axboe @axboe
13K Followers 302 Following Linux kernel IO dabbler @ Meta @[email protected] Axboe Racing https://t.co/dog9gog5lf
Adrian @adriangb01
573 Followers 488 Following
Maciek Sakrejda @a_maciek_moment
314 Followers 338 Following Bit-twiddler and pixel pusher. Enjoys and aspires to good UX. React, Postgres, and unafraid of diving into unfamiliar code. Now @pganalyze, former Heroku Data.
Andrew Atkinson @andatki
2K Followers 0 Following 👉 Not using X, please find me at the links below. Thanks!
Postgres FM @PostgresFM
2K Followers 3 Following A weekly podcast about all things PostgreSQL — by @michristofides and @samokhvalov. Also at https://t.co/lQaOt18aZ0
PGConf Europe @pgconfeu
2K Followers 0 Following Please follow us on Mastodon @[email protected] or Bluesky https://t.co/hKV42jDE1I
Mim @mim_djo
12K Followers 3K Following #MicrosofFabric user advocate, interests in Small Data & Self Service #Microsoftemployee since Dec 2023 , but my tweets are my own
Sarah O'Connell @SarahOC_MECFS
5K Followers 5K Following #pwME patient 13 yrs & mum of 2 with ME, #LongCovid & PANS • ME & LC Advocate • Co-Founder LCAI • Women's Health; Endometriosis,PMDD • Sci-fi & movie lover
OtterTune @OtterTuneAI
3K Followers 226 Following Automatically improve your Amazon RDS and Aurora MySQL and PostgreSQL database efficiency & performance.
Candles and Chronic I... @candlelovers12
854 Followers 310 Following Disabled spoonie. lover of candles and stuff. #pwME #POTS. Link is Gourmet Candle affiliate link a small. business that makes delicious food like candles.
Will King @willking
3K Followers 972 Following Design Engineer @snowflake (via @crunchydata) — Head Coach @terminaldotshop — Married to the girl of my dreams @littlealison93 — Psalms 118:24
#MEAction Network @MEActNet
19K Followers 2K Following A global network fighting for equality for Myalgic Encephalomyelitis. #MEAction #MillionsMissing https://t.co/JhhNZoFYJi
@richardvallee.bsky.s... @richardvallee
3K Followers 4K Following I play language. Mostly irreverent. Debugger. AI. Global warming. Integrity. Healthcare. Science. We are actually in the pre-truth era. #MillionsMissing
Crucial Memory @CrucialMemory
312K Followers 960 Following Crucial delivers best-in-class memory and storage solutions that enhance system performance, allowing you to game harder, create smarter and build better.
Renegade Research @RenegadeRes
3K Followers 3K Following Patient-led 501(c)(3) nonprofit working on #MECFS & #LongCovid💙 Runs project @remissionbiome • https://t.co/W0iQqqSYY2
Jeannette Burmeister @JKBurmeister
3K Followers 701 Following Attorney (California, formerly licensed in Berlin, Germany), successfully sued NIH + HHS for ME-related FOIA violation (incl. all of $140k attorneys' fees)
Todd Davenport @sunsopeningband
13K Followers 4K Following Chief rapscallion & picaroon. Husband. Dad x3. Upstreamist. Pracademic. Storyteller. It’ll be ok in the end. If it’s not ok then it ain’t the end. DPT PhD MPH.
Brendan Gregg @brendangregg
50K Followers 155 Following Makes things fast. Expert in computer performance and eBPF. OpenAI, ex-Netflix. Created flame graphs. Aussie. Opinions my own. [email protected]
Paul Laurence @prlaurence
95 Followers 132 Following Postgres @snowflake @crunchydata. Previously Emerging Companies at @cooleyllp
Marco Slot @marcoslot
1K Followers 662 Following Mostly tweets about Postgres, Snowflake Postgres, and Postgres extensions. Formerly Crunchy Data, Microsoft, Citus Data, AWS, TCD, VU
Oleg Bartunov @obartunov
2K Followers 252 Following Research sci at Sternberg Astronomical Institute, Moscow University CEO Postgres Professional
Gabriele Bartolini @_GBartolini_
1K Followers 333 Following Open Source, PostgreSQL, databases, Kubernetes, Lean and DevOps. @CloudNativePG maintainer. DoK Ambassador. Blues music, guitars.
Framework @FrameworkPuter
119K Followers 243 Following Remaking consumer electronics to respect people and the planet. 💻🪛 For support visit https://t.co/OcUxJ6ebU3
Solve ME/CFS Initiati... @PlzSolveCFS
12K Followers 4K Following Making ME/CFS, Long Covid & associated conditions widely understood, diagnosable, & treatable. #SolveME #MECFS #LongCovid Donate @ https://t.co/P6umwzCRA4
MEpedia @MEencyclopedia
3K Followers 703 Following The MEAction encyclopedia, crowd-sourcing the history, policy & science of the disease. Edit and improve an article today! @MEActNet
Bateman Horne Center @BatemanHorne
7K Followers 1K Following Bateman Horne Center is a non-profit medical, research, and education center devoted to eradicating ME/CFS, FM, Long COVID, and related conditions.
Maureen Hanson @DrMaureenHanson
6K Followers 143 Following I am a Professor in the Molecular Biology and Genetics Department at Cornell University in Ithaca, NY.
Christoph Ströck @cstroeckw
9K Followers 760 Following Soon, people will look back in disbelief at what happened to patients with ME/CFS | Co-founder @weandmecfs | Godspeed 🙇🏼
Naomi Harvey “PhD W... @Naomi_D_Harvey
17K Followers 4K Following Zoologist. She/her. ME/CFS since 2002, now Severe. Pro-vax but vaccine injured. Life on pause (views my own - unemployed) ♿️ https://t.co/YeMrEWwEg5
Roberto Mello @robertobmello
550 Followers 1K Following Helping people improve their reliability and performance. Love data. Loving this new era of coding agents. Polyagentamorous. Long-time PostgreSQL guy.












