I added an index to speed up one query and it made things worse. Here is the Postgres mechanism behind it, how I confirmed it with EXPLAIN, and what I do instead.
@mh2333.bsky.social
@mh2333.bsky.socialI added an index to speed up one query and it made things worse. Here is the Postgres mechanism behind it, how I confirmed it with EXPLAIN, and what I do instead.
@pgsummitus.bsky.socialThinking about attending PG Summit US but not sure how to fund it? As a community event, PG Summit US attendees are eligible to apply for Opportunity Grants that help fund travel expenses.
@mh2333.bsky.socialI added an index to speed up one query and it made things worse. Here is the Postgres mechanism behind it, how I confirmed it with EXPLAIN, and what I do instead.
@turnstep.bsky.socialInteresting discussions about increasing the frequency of Postgres releases. Looks like we will end up somewhere more frequently than quarterly and less often than monthly. #postgres
@turnstep.bsky.socialThis was so much fun to read: www.snowflake.com/en/blog/engi... #postgres #postgresql
@pgsummitus.bsky.socialStill on the fence about attending Postgres Summit US? Not sure how to approach your manager about conference expenses? We make it easy! Check out our “Make the Case” page. It contains all the information you need!
@pgus.bsky.socialPgUS is looking for volunteers! We have jobs both large and small so even if you only have a little time to give, we’d love to hear from you!
@pgus.bsky.socialAttending KCDC? It’s your last chance to stop by our Community Booth to talk Postgres and community!!!
@pgsummitus.bsky.socialDevrim Gündüz and Ryan Booz will be holding a 2 part Postgres Beginner’s Workshop at Postgres Summit US 2026!
@pgexperts.bsky.socialPGX is proud of our commitment to the PostgreSQL Community. Our employees are making a difference by being involved with PgUS!
@pgsummitus.bsky.socialPG Summit US will be held at Convene in the heart of SoHo! It’s a new venue for us and we’re really excited about its convenient location and lovely facilities!
@pgus.bsky.socialYour weekend watch is “Logical replication is for more than just ETL: building PgCache” with James Nelson and Philip Johnston:
@pgedge.bsky.socialThe 8pm speaker slot at #PostgresEDI is still open. Thursday 24 Sept, 6pm, Paterson's Land, Edinburgh. Free, with pizza 🍕
Jimmy Angelakos opens at 19:00 on ColdFront: #OpenSource #Postgres data tiering to Apache Iceberg.
Want the other slot? ✉️ [email protected]
@pgus.bsky.socialIf you’re passionate about Open Source and attending KCDC, we’ve got an event for you! Join us tonight for KC OSS Happy Hour!
@pgsummitus.bsky.socialJoin us for “A PostgreSQL 19 Whirlwind Tour” with Jonathan Katz at Postgres Summit 2026!
@pgus.bsky.socialAttending KCDC? Our Community Booth is here today and tomorrow! Stop by to talk Postgres and community!
@pgus.bsky.socialThe PgUS Community Development Committee works hard to ensure that our community is safe and welcoming to everyone! How do we do that? Click the link below for more info!
@vyruss.orgNail-biting suspense! Is #PostgreSQL on a Raspberry Pi faster than a cloud managed instance?! Chris Ellis explores at @pgdaylowlands.bsky.social.
#Postgres #RPI #RaspberryPi #cloud #database #OpenSource #PGDayNL
@vyruss.org@magnus.hagander.net kicking off @pgdaylowlands.bsky.social by telling us what's coming in #PostgreSQL 19, sadly without musical accompaniment. #pgdaynl #postgres
@happy-homhom.bsky.social