Jeremy Schneider @jer_s

Building and running reliable data platforms that scale and perform. An organizer of Seattle Postgres User Group. My opinions are my own. about.me/jeremy_schneid… Seattle, WA Joined May 2011

Tweets

5K
Followers

2K
Following

415
Likes

6K

Jeremy Schneider @jer_s

3 weeks ago

@FranckPachot @tudor_g Your main point is correct - no FPWs on Aurora My tweet quoted the aurora paper, just to be safe 🙂

0 0 1 24 0

View Details

@FranckPachot @tudor_g The storage nodes manipulate local SSDs and interact with database engine instances, other peer storage nodes, and the backup/restore services that continuously backup changed data to S3 and restore data from S3 as needed.

1 0 1 33 0

View Details

Jeremy Schneider @jer_s

3 weeks ago

@ahachete @AWS this cant be real

1 0 1 27 0

View Details

Jeremy Schneider @jer_s

3 weeks ago

@FranckPachot @tudor_g Aurora does not store data on EBS

1 0 0 45 0

View Details

Jeremy Schneider @jer_s

3 months ago

We need to re-think OSS contribution attribution in light of AI. More than ever, it's important for committers to give credit on where the ideas are coming from. A committer can copy/paste someone else's ideas into their own prompts, and they need to give appropriate credit.

0 0 3 132 0

View Details

Jeremy Schneider @jer_s

4 months ago

@nikitabase i was really expecting some kind of pun after your first sentence

0 0 0 70 0

View Details

Jeremy Schneider @jer_s

4 months ago

@kellabyte @TanelPoder lets name it "hadoop" 😅 this is a better approach with less risk of bottleneck on a single server cpu oracle RAC is never local to the storage anyway, shared storage = always a network hop my hesitations w db PLs as religion [1] single server cpu [2] version control of code

1 0 1 54 0

View Details

Jeremy Schneider @jer_s

4 months ago

@sborden76 @planetpostgres here's the commit - i think it's pretty lightweight github.com/postgres/postg… mainly another RegisterTimeout() call in postinit.c InitPostgres() interesting discussion postgresql.org/message-id/fla…

1 0 1 34 1

View Details

Jeremy Schneider @jer_s

4 months ago

@BonesMoses then we will be running out of money

0 0 0 38 0

View Details

Jeremy Schneider @jer_s

4 months ago

Poisoned conn pools in Go can escalate from row-level brownouts to complete db outages. This test suite demonstrates the failure cascade and shows how PgBouncer's peering feature (v1.19+) prevents the escalation; although fixing leaks at the app level remains the true solution.

Planet PostgreSQL @planetpostgres

4 months ago

Jeremy Schneider (@jer_s): How Blocking-Lock Brownouts Can Escalate from Row-Level to Complete System Outages postgr.es/p/7qE

0 9 27 3K 13

0 1 5 321 1

View Details

Jeremy Schneider @jer_s

6 months ago

@xeraa @jpscaletti @cole1809 @dhh yes, my impression is that both elastic and mongo are now using terminology in a more responsible way

1 0 1 37 0

View Details

Jeremy Schneider @jer_s

6 months ago

@xeraa @jpscaletti @cole1809 @dhh IIRC both mongo and elastic initially claimed SSPL was open source, before eventually backing down and changing their positions? (the history is why this DHH thing puzzles me so much) opensource.org/blog/the-sspl-…

1 0 0 43 0

View Details

Jeremy Schneider @jer_s

6 months ago

@jpscaletti @cole1809 @dhh "source available" is the correct term. after mongodb, elasticsearch, confluent, hashicorp, etc ... i did not expect dhh (of all people!) to go the mongo/elastic route of trying to use the term "open source" like this

1 0 2 92 0

View Details

Jeremy Schneider @jer_s

6 months ago

@MarkusWinand this is great!

0 0 1 76 0

View Details

Yawd @el_yawd

6 months ago

Learnt how to develop Postgres extensions, pretty neat

0 2 14 701 0

View Details

Jeremy Schneider @jer_s

6 months ago

@BenjDicken I have said many times to many people - the thing I love most about working with relational databases is that you can touch on almost every aspect of computer science here, from theory and high-level algorithms down to low-level hardware design details

1 0 12 1K 0

View Details

Akhilesh Mishra @livingdevops

6 months ago

@SumitM_X English.

0 1 8 2K 0

View Details

Jeremy Schneider @jer_s

6 months ago

great read

Kelly Sommers @kellabyte

9 months ago

You asked for longer rants, so here are longer rants! After almost 10 years I'm back to blogging. Thanks for the encouragement. Link below in the thread 🔻

27 33 215 48K 90

1 0 3 1K 1

View Details

Jeremy Schneider @jer_s

6 months ago

@dave_cramer @samokhvalov @kellabyte the new async IO code will need to be instrumented differently but a sync OS call to read() data from a file always waits, regardless of short wait for pagecache or long wait for physical IO ability to profile DB and see state of active conns is very valuable

0 0 0 48 0

View Details

Jeremy Schneider @jer_s

6 months ago

@dave_cramer @samokhvalov @kellabyte the wait_event column of pg_stat_activity is supposed to indicate if a process of "waiting" for something (like I/O)