Ryan

@ryansmith

115 Following

2749 Followers

Ryan pfp

1 reply

3 recasts

31 reactions

Ryan pfp

It's quite rich that the "Tablespaces" section follows the "Destroying a Database" section since misconfiguring table spaces is an excellent way to absolutely hose your database.

1 reply

2 recasts

4 reactions

Ryan pfp

pg_column_size is nice. I knew a bigint was 8 bytes, but I was curious to see the storage size for comparable numeric data.

1 reply

2 recasts

11 reactions

Ryan pfp

Really handy tool for analyzing email headers: https://toolbox.googleapps.com/apps/messageheader/analyzeheader Had to use this to figure out email delays. Sendgrid was reporting instant delivery. Turns out google was adding delay because I had a fresh dedicated IP from Sendgrid. TIL you need to "warm up" an ip.

0 reply

3 recasts

22 reactions

Ryan pfp

What every programmer should know about solid-state drives https://codecapsule.com/2014/02/12/coding-for-ssds-part-6-a-summary-what-every-programmer-should-know-about-solid-state-drives/

0 reply

0 recast

13 reactions

Ryan pfp

Thanks to everyone who came to my talk. Here are my slides: https://docs.google.com/presentation/d/1FBpmCFX8yxJAxE9pPgMjDeSO8B54DKR9BLDDzqtPTHo

1 reply

3 recasts

24 reactions

Ryan pfp

Proof by contradiction is my passion

3 replies

5 recasts

54 reactions

Ryan pfp

Mr. @0xsmallbrain is giving a good talk

2 replies

2 recasts

18 reactions

Ryan pfp

I love drinking coffee

1 reply

1 recast

14 reactions

Ryan pfp

Scotty Pippen is talking with Satoshi in his dreams and you're still bearish, anon? https://x.com/scottiepippen/status/1831074924217438310

1 reply

1 recast

9 reactions

Ryan pfp

A lot of discussion around exactly how many PG tips I will be sharing during my talk at Devcon (Wednesday at 2pm) I can't saw how many exactly, but there will be many. Including a few that I've never shared before. From the depths of the Postgres documentation!

3 replies

0 recast

19 reactions

Ryan pfp

Just got a deliciously fermented coffee at: Invisible Coffee Room A+++ Would go again Give it a try if you are in Bangkok for Devcon https://g.co/kgs/B7RA9ff

2 replies

3 recasts

7 reactions

Ryan pfp

https://app.devcon.org/schedule/BGGFDD Would love to put names to faces at Devcon. If you follow me you're likely into databases and whatnot. Perhaps after my talk we can all nerd out on systems stuff. Please drop by the talk and say hi!

2 replies

6 recasts

25 reactions

Ryan pfp

PLEASE ATTEND MY TALK IF: 1. You want my secret Postgres tricks (some. won't give away all) 2. You want to know what has worked well and not so well 3. You won't heckle me too much. A little heckle is ok https://app.devcon.org/schedule/BGGFDD

2 replies

6 recasts

20 reactions

Ryan pfp

Years ago I looked at HAMMER as an alt for ZFS. At the time it lacked features like compression. It looks like the default for Dragonfly BSD is now HAMMER2 -- which now has compression, dedup, etc. tldr DragonFlyBSD is very interesting: https://www.dragonflybsd.org/history/

0 reply

2 recasts

8 reactions

Ryan pfp

Damn. Screen shot from this talk on PG/ZFS https://people.freebsd.org/%7Eseanc/postgresql/scale15x-2017-postgresql_zfs_best_practices.pdf

2 replies

1 recast

12 reactions

Ryan pfp

https://notryan.com/code What a fantastic web page

1 reply

1 recast

15 reactions

Ryan pfp

Config for running PG on ZFS https://vadosware.io/post/everything-ive-seen-on-optimizing-postgres-on-zfs-on-linux/

1 reply

1 recast

12 reactions

Ryan pfp

Do you like databases? Do you like Postgres? Please join /pg If you reply with an interesting tidbit re: pg I will insta-member you!

1 reply

5 recasts

18 reactions

Ryan pfp

Fun PG-related meetup for the SF folks

0 reply

0 recast

6 reactions