Gregory Smith @postgresperf
#PostgreSQL startup founder @crunchydata, author, lapsed #planetpostgresql blogger. Family advocate for #MyalgicEncephalomyelitis #POTS #PwME #MEcfs patients. Baltimore, MD Joined September 2011-
Tweets219
-
Followers459
-
Following95
-
Likes83
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…
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:
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: https://t.co/iSnhhd0Ckz
Made my own version of the Godzilla Easter picture that's gone viral this year.
I don't just make Crunchy dog food, I'm also a customer.
I don't just make Crunchy dog food, I'm also a customer.
You are a specialized financial assistant containing information on daily opening price, closing price, high, low, volume, and reported earnings, but not how to write SQL queries. Poor pg_sleep(), it never meant to be a malicious query. huntr.com/bounties/44e81…
The new Apple Studio models have a familiar server trade-off: lots of memory sacrifices core speeds. M3 Ultra looks great for >128GB of RAM workloads; perfect fit for GPU bound work or local AI models. General use, I would not want to return to M3 cores now that I'm used to M4.
During index tinkering I save a snapshot of the index stats and/or run pg_stat_reset, make the change, and then monitor the new block rate of I/O to the indexes. The index block read stats show the new hot and dead spots. My WIP catalog query samples: github.com/CrunchyData/pg…
During index tinkering I save a snapshot of the index stats and/or run pg_stat_reset, make the change, and then monitor the new block rate of I/O to the indexes. The index block read stats show the new hot and dead spots. My WIP catalog query samples: github.com/CrunchyData/pg…
Bring us your shootout tests; we see this scale of improvement from migrations all the time now. Getting everything right to perform as well as possible on all our cloud Postgres platforms, that has been a long decade of sweating every performance detail.
Bring us your shootout tests; we see this scale of improvement from migrations all the time now. Getting everything right to perform as well as possible on all our cloud Postgres platforms, that has been a long decade of sweating every performance detail.
I really enjoyed working through Paul's GIS examples here this week. Seeing a nested WITH query that generates a flight plan between two airports, that is a great piece of demo code.
I really enjoyed working through Paul's GIS examples here this week. Seeing a nested WITH query that generates a flight plan between two airports, that is a great piece of demo code.
Surprisingly competitive? I guess. I've watched PG absorb so many former specialty use cases, I consider it the expected outcome when it happens again.
Surprisingly competitive? I guess. I've watched PG absorb so many former specialty use cases, I consider it the expected outcome when it happens again.
Our yearly PostGIS conference is tomorrow, and I'm happy to just blog about my subject area and tune in. I don't even ask for speaking time anymore because we have too many cool PG projects like this one presenting.
Our yearly PostGIS conference is tomorrow, and I'm happy to just blog about my subject area and tune in. I don't even ask for speaking time anymore because we have too many cool PG projects like this one presenting.
All true. The way the VACUUM truncation works confuses people sometimes. The database has to exclusive lock the very last page of the table to shrink the file. It does that over and over again, until it finds a page that's still live.
All true. The way the VACUUM truncation works confuses people sometimes. The database has to exclusive lock the very last page of the table to shrink the file. It does that over and over again, until it finds a page that's still live.
I have repeatedly tried over the years to use the NYC taxi data set for benchmarks or demos. There's always been some snag in getting the data cleaned or loaded or *something*. Seeing it done in two lines of code with our SaaS, it really highlights the product's use case.
I have repeatedly tried over the years to use the NYC taxi data set for benchmarks or demos. There's always been some snag in getting the data cleaned or loaded or *something*. Seeing it done in two lines of code with our SaaS, it really highlights the product's use case.
Greg Smith (@postgresperf): Loading the World! OpenStreetMap Import In Under 4 Hours postgr.es/p/6If
For five years now I've been running my own private server with a world map data set, as a benchmark workload. The whole Planet imports and indexes in 4 hours now. That represents a build rate of 200GB/hour using a single database disk. crunchydata.com/blog/loading-t…
Craig Kerstiens @craigkerstiens
9K Followers 884 Following Product and eng @crunchydata. I blog at https://t.co/K49pnYYXpL Curate https://t.co/0DWATfO0yf. Previously @Microsoft, @citusdata, @Heroku, Truviso
Pavlo Golub @PavloGolub
2K Followers 405 Following PostgreSQL expert @PostgresSupport. Programmer. Engineer. 🇺🇦 https://t.co/2tSLn4Jju2
Devrim Gündüz @DevrimGunduz
4K Followers 314 Following Works at @EDBPostgres, runs @GITCPro. Open source geek, PostgreSQL major contributor, RPM packager, F1 fan, and daddy. Türkçe: @DevrimGunduzTR
Christopher Winslett @winsletts
873 Followers 595 Following a unitasker. golf, family, a little of everything. work @Snowflake (via @CrunchyData) Offers free, but not unsolicited, marriage advice.
Paul Ramsey @pwramsey
7K Followers 232 Following Please find me at @[email protected] @pwramsey.bsky.social
Douglas J Hunley @hun... @hunleyd
470 Followers 184 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
5K Followers 369 Following Co-founder/CTO, @TigerDatabase / @TimescaleDB 🐯🦄. Professor, @PrincetonCS. Distributed systems, databases, AI, security, networking.
Bertrand Drouvot @BertrandDrouvot
2K Followers 619 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 speaker, PostgreSQL Expert, jq & vim fan. He/him. 🍉✡ No employer has hired me to speak for them through this account, or will
Jeremy Schneider @jer_s
2K Followers 420 Following Building and running reliable data platforms that scale and perform. An organizer of Seattle Postgres User Group. My opinions are my own.
Peter Geoghegan @petervgeoghegan
2K Followers 198 Following PostgreSQL hacker. Irish expat. A theoretician's practitioner.
Thomas Munro @MengTangmu
2K Followers 370 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
6K Followers 2K Following Trusted Open Source PostgreSQL and Enterprise PostgreSQL Support, Technology and Training
Dan Langille @dvl@bsd... @DLangille
3K Followers 522 Following Mountain biker. Dev turned sysadmin. Websites & databases. Conference organizer. Practical examples are best. Pizza. Beer. Movies. (he/him)
hydrobiont @the_hydrobiont
417 Followers 227 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
Andrew Atkinson @andatki
2K Followers 284 Following
Jaime Casanova @JCasanovaEC
683 Followers 417 Following Director de Servicios Profesionales en SystemGuards. Experto en PostgreSQL. Miembro del PGDG.
Savanamaga @savanamagaB
9 Followers 592 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 ✍️📌
Siqu @Siqu981
13 Followers 620 Following
Mineaki Motohashi @mmotohas
2K Followers 342 Following 日本にSnowflakeを持ち込んだ人。SnowflakeのConsulting Manager、テクノロジーエバンジェリスト。 Oracle→Accenture→True Data CTO→Sigmaxyz→Snowflake。趣味はボウリング、サウナ、筋トレ。Tweets are my own.
geoff brown @geoffbr85790890
203 Followers 912 Following 1988 m.e /fm/MCS/CMV/toxoplasmosis/Grover's disease/ severe pain and it's still the same in 2024
Lilian @Lilianqueen33
292 Followers 4K Following Crypto Trader & Analyst I BTC & ETH Enthusiast l Daily insights
bhavani-DBA @bhavanidba
251 Followers 1K Following
Raymond Kemonde @RaymondKemonde
565 Followers 3K Following Techie, Avid-reader, Writer, Witty and Leader. #stablegenius DBA ~ Databases, Servers, Storage.
Sylwester Lachiewicz @slachiewicz
307 Followers 4K Following
geoslice @geoslice
304 Followers 5K Following
Mike Fridman @_mfridman
713 Followers 954 Following technology, landmarks, left joins and Go vibes. Protocol Buffers for the rest of us @bufbuild
jw @jonwarnick
184 Followers 886 Following EU is preparing war to distract from their economic collapse. "Never go to sea with two chronometers; take one or three." src/util.cpp
Emil Stolarsky @EmilStolarsky
1K 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
103 Followers 1K Following C & Go & Elixir & Solidity Dev. Crypto & AI & Robotics Builder. https://t.co/JdToS8skhK
12345 @simping4eggman
0 Followers 8 Following I do chaos magick under the premise of ios development
Joan U.S.minsky 💯�... @JuanLluesma
809 Followers 1K Following #parlavalencià #portugaldelest #regnicoles #vcf #limout #postgres #padel #etseuv #armossar forasters=nacionalmadridisme=nacionalbarcelonisme
Totiseau @TotiseauugUo
59 Followers 2K Following
Rueneark @Rueneark3S76b
116 Followers 3K Following
Jennifer McCallister @Jeff58159Sharon
13 Followers 308 Following
Renegade Research @RenegadeRes
2K Followers 3K Following Patient led nonprofit 501c3 on #MECFS & #LongCovid • https://t.co/Tv4Sb4yLzd 💙 Runs project @remissionbiome • Donate ▶️ https://t.co/Qovzyu0mqp
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
5 Followers 358 Following
Michael J Weirsky @JWeirsky13
123 Followers 4K 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_
99 Followers 2K Following
Christian Humer @grashalm_
2K Followers 414 Following Working on Truffle/GraalVM at Oracle Labs. ME/CFS Caretaker and Activist (https://t.co/gWxW16A5Op). Austrian expat in Zurich. https://t.co/piKOfYIYCL
Leah Zamora Johnson @leah_johns93820
91 Followers 2K Following
Mohammed Rai @MohammedRai79
6 Followers 188 Following
Juha Juutinen @juhajuutinen
89 Followers 2K Following Solution Architect / SW Engineer | Cloud, Backend, Linux, Android | Kotlin, Python, Rust
Paul Friedrich Schulz @pfs1337
81 Followers 907 Following
Ky Dinh @KyDinh15
24 Followers 372 Following
Cavezzan Patrice @pcavezzan
190 Followers 596 Following
Markus Schirp @_m_b_j_
1K Followers 371 Following Master of Disaster. Mutation testing. Dynlang Exorcist. Expat German. Domain in PostgreSQL. Domain IO in Rust / Haskell. Creative consistent typos. DMs open.
Claudin @dinclas_
45 Followers 287 Following
林冠呈 GUAN-CHENG ... @JackLin36820
21 Followers 687 Following
Christopher Ogden @c_t_ogden
365 Followers 6K Following Software engineer · Avid reader · Projects sundry · Let's collaborate · Smalltown life
Aurélien Belaud @aurl_bld
253 Followers 2K Following Bryologue-géomaticien installé dans le Sud-Ouest
Nik Samokhvalov @samokhvalov
11K Followers 51 Following Talk to me if you have issues with your Postgres databases: [email protected] // I stand with Ukraine // @postgres_ai & @Database_Lab & @PostgresFM
Craig Kerstiens @craigkerstiens
9K Followers 884 Following Product and eng @crunchydata. I blog at https://t.co/K49pnYYXpL Curate https://t.co/0DWATfO0yf. Previously @Microsoft, @citusdata, @Heroku, Truviso
Planet PostgreSQL @planetpostgres
41K Followers 1 Following Blog entries from members of the PostgreSQL community
xzilla @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 314 Following Works at @EDBPostgres, runs @GITCPro. Open source geek, PostgreSQL major contributor, RPM packager, F1 fan, and daddy. Türkçe: @DevrimGunduzTR
Christopher Winslett @winsletts
873 Followers 595 Following a unitasker. golf, family, a little of everything. work @Snowflake (via @CrunchyData) Offers free, but not unsolicited, marriage advice.
Paul Ramsey @pwramsey
7K Followers 232 Following Please find me at @[email protected] @pwramsey.bsky.social
kolektiva dot social ... @davidfetter
1K Followers 2K Following Parent, Abolitionist, World-wide speaker, PostgreSQL Expert, jq & vim fan. He/him. 🍉✡ No employer has hired me to speak for them through this account, or will
Peter Geoghegan @petervgeoghegan
2K Followers 198 Following PostgreSQL hacker. Irish expat. A theoretician's practitioner.
PostgreSQL @PostgreSQL
54K Followers 1 Following PostgreSQL - The world's most advanced Open Source Database
Thomas Munro @MengTangmu
2K Followers 370 Following PostgreSQL and sometimes FreeBSD hacker. https://t.co/xNzXgIYxiF, tmunro on libera
Crunchy Data @crunchydata
6K Followers 2K Following Trusted Open Source PostgreSQL and Enterprise PostgreSQL Support, Technology and Training
Devrim Gündüz @DevrimGunduzTR
7K Followers 290 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
Andrew Atkinson @andatki
2K Followers 284 Following
Elizabeth Garrett Chr... @sqlliz
652 Followers 831 Following Doing fun things with Postgres @snowflake via @crunchydata. Married to @pg_dwc.
Fujii Masao @fujii_masao
1K Followers 249 Following PostgreSQL committer, Database Technical Lead at NTT DATA, maybe good husband & father.
Magnus Hagander @magnushagander
3K Followers 368 Following opensource advocate. @postgresql core team, committer, infrastructure team, board of @postgresqleu, sailor. working at https://t.co/hA9OMICq8n
Michael R Scoma MD @DrMichaelScoma
8K Followers 98 Following Infectious Disease Immunology physician specializing in complex chronic diseases. Views are my own; no medical advice given.
Christian Humer @grashalm_
2K Followers 414 Following Working on Truffle/GraalVM at Oracle Labs. 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 248 Following https://t.co/Sd7aWQerOs offers news and in-depth reviews of the entire enterprise IT stack from AI to end user computing and everything in between.
Ray Lucchesi @RayLucchesi
5K Followers 84 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
Dr. Michael DACM🇱�... @internetuserf12
7K Followers 478 Following Herbalist, Acupuncturist; #LongCovid since November 2020; ME + ITP since who knows he/they 🍉 #ZeroCovid #N95 [email protected]
onder kalaci @onderkalaci
184 Followers 516 Following
Average Database CEO @AvgDatabaseCEO
4K Followers 251 Following CEO of AvgDB. $100m series B. Now doing Auth and Storage!
Velu Erwan @erwanaliasr1
1K Followers 493 Following Opensource enthusiast & contributor, interested in low-level and performance. Kernel Recipes founder, general #teamkrampouz. Beekeeper in free time.
Adrian @adriangb01
558 Followers 486 Following
Maciek Sakrejda @a_maciek_moment
325 Followers 344 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.
dax @thdxr
61K Followers 228 Following building https://t.co/eVz8bbXqxp https://t.co/A7BKeXDXKQ https://t.co/KFQgBnHJQy https://t.co/ZjFDwZeABC
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
11K 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
4K Followers 5K Following #pwME patient 12 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 227 Following Automatically improve your Amazon RDS and Aurora MySQL and PostgreSQL database efficiency & performance.
Candles and Chronic I... @candlelovers12
824 Followers 257 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 @wking__
2K Followers 645 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 3K Following A global network fighting for equality for Myalgic Encephalomyelitis. #MEAction #MillionsMissing https://t.co/JhhNZoFYJi
@richardvallee.bsky.s... @richardvallee
3K Followers 5K 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
316K Followers 968 Following The Memory Experts™ at Crucial are here for your memory upgrade needs! We offer 250,000 upgrades for more than 50,000 systems. Why go anywhere else?
Renegade Research @RenegadeRes
2K Followers 3K Following Patient led nonprofit 501c3 on #MECFS & #LongCovid • https://t.co/Tv4Sb4yLzd 💙 Runs project @remissionbiome • Donate ▶️ https://t.co/Qovzyu0mqp
Jeannette Burmeister @JKBurmeister
3K Followers 716 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 More magician than researcher. 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
47K Followers 156 Following Makes things fast. Expert in computer performance and eBPF. Intel Fellow, ex-Netflix. Created flame graphs. Aussie. Opinions my own. [email protected]
Paul Laurence @prlaurence
92 Followers 113 Following Trusted Open Source Postgres @crunchydata. Previously Emerging Companies at @cooleyllp
Marco Slot @marcoslot
1K Followers 656 Following Mostly tweets about Postgres, Crunchy Data, and Postgres extensions. Formerly Crunchy Data, Microsoft, Citus Data, AWS, TCD, VU
Oleg Bartunov @obartunov
2K Followers 253 Following Research sci at Sternberg Astronomical Institute, Moscow University CEO Postgres Professional
Gabriele Bartolini @_GBartolini_
1K Followers 334 Following Open Source, PostgreSQL, databases, Kubernetes, Lean and DevOps. @CloudNativePG maintainer. DoK Ambassador. Blues music, guitars.
Framework @FrameworkPuter
95K Followers 197 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 717 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 146 Following I am a Professor in the Molecular Biology and Genetics Department at Cornell University in Ithaca, NY.
Christoph Ströck @cstroeckw
8K Followers 604 Following Soon, people will look back in disbelief at what has happened to patients with ME/CFS | Godspeed 🙇🏼
Naomi Harvey PhD #Wea... @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
452 Followers 1K Following Helping people, companies, systems, improve their reliability and performance. Love data. Long-time PostgreSQL guy. https://t.co/gTPkMSJERe
Amit Kapila @kapila_amit
426 Followers 46 FollowingTrends for United States
You might like
