Ryan

@ryansmith

122 Following

3566 Followers

Ryan pfp

re: space. I like this idea. Let's do it!

1 reply

0 recast

0 reaction

Ryan pfp

@bytebot does this match your understanding?

1 reply

0 recast

0 reaction

Ryan pfp

I’m afraid my best argument will be: works on my machine

0 reply

0 recast

1 reaction

Ryan pfp

A rebuttal to Uber’s PG/MySQL paper. Keep in mind, PG has changed since this discussion. A lot of the replication issues are long since put to rest. The storage sub-systems are the interesting point of difference between these systems. MYSQL’s indexes point to primary keys instead of a CTID. An update to a MySQL row will have same storage location but PG will be a new CTID/page — unless it was a Heap Only Tuple (HOT) update. But this means PG can reduce IO for queries. As with anything, it’s always a tradeoff. However, database systems in particular are especially sensitive to workload details. The tradeoffs really matter! https://thebuild.com/presentations/uber-perconalive-2017.pdf

1 reply

1 recast

9 reactions

Ryan pfp

I've seen pg-nano-like projects over the years. The all-or-nothing approach to stored procedures is not a good idea. That being said, @indexsupply 's performance is due (in large part) to stored procedures. I use them when I need to push computation to the storage. I don't need a framework for this. I just do it carefully and intentionally. They work best when used as a small, sharp knife.

0 reply

0 recast

1 reaction

Ryan pfp

Interesting. I wonder if you could get the same kind of abstraction with a stored procedure

1 reply

0 recast

1 reaction

Ryan pfp

Uber isn’t a wholesale success story. There are a lot of caveats that you can search for. The big win for them was reduced write amplification (and binary replication) due to how PG does indexes. Unless you are doing 100k writes / second I doubt this will matter.

0 reply

0 recast

2 reactions

Ryan pfp

Interesting. I wonder why.

1 reply

0 recast

1 reaction

Ryan pfp

I do not share the OP’s sentiment.

0 reply

0 recast

5 reactions

Ryan pfp

“Just in case” Love it!

0 reply

0 recast

1 reaction

Ryan pfp

I've been working on a TS client for @indexsupply. Coming soon (or now if you sleuth the GH account)

0 reply

2 recasts

13 reactions

Ryan pfp

I was having some issues getting my @indexsupply transactional emails delivered timely. I found this absolutely cracked email guy https://www.helloinbox.email who helped me figure it out. (problem was part dns and part message formatting) would highly recommend if you want to speed run your email issues

0 reply

2 recasts

8 reactions

Ryan pfp

really enjoying this one. ty

0 reply

0 recast

4 reactions

Ryan pfp

0 reply

0 recast

0 reaction

Ryan pfp

2 replies

4 recasts

12 reactions

Ryan pfp

I've been curious about FreeBSD for years. Taking some holiday time to explore and try things out.

0 reply

0 recast

1 reaction

Ryan pfp

0 reply

0 recast

1 reaction

Ryan pfp

lol i'm using the tv as a display for my workstation (below desk) while I install FreeBSD on it. And then Postgres.

1 reply

0 recast

0 reaction

Ryan pfp

@samuellhuber.eth plz post your desk pic

1 reply

0 recast

1 reaction

Ryan pfp

Oh no! Is this desk the nerds equivalent to Steve's black turtleneck?

1 reply

0 recast

1 reaction