Ryan

@ryansmith

115 Following

2757 Followers

Ryan pfp

1 reply

3 recasts

32 reactions

Ryan pfp

been trying to explain this to my woman for years!

0 reply

0 recast

2 reactions

Ryan pfp

ah. ye ole outdated random page cost

0 reply

1 recast

1 reaction

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

5 reactions

Index Supply pfp

If you are querying WowTokenCreated on the Index Supply free plan, please reach out to me as I have a query suggestion for you. It will bring your cold query latency from a couple of seconds down to ~150ms. here is the faster query: https://tinyurl.com/wowtoken-with-addr

2 replies

2 recasts

19 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

what's your favorite brew method?

0 reply

0 recast

0 reaction

Ryan pfp

Interesting. I think we need more layers l/acc

0 reply

0 recast

0 reaction

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

2 replies

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

0 reply

0 recast

1 reaction

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

Are the flavours good?

1 reply

0 recast

0 reaction

Ryan pfp

0 reply

0 recast

1 reaction

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

20 reactions

Ryan pfp

Ty! Not sure if the conference will be posting. But I will be posting my notes online.

0 reply

0 recast

1 reaction