Ryan

@ryansmith

133 Following

4285 Followers

Ryan pfp

https://stackoverflow.com/a/8391601 Fascinating code to get max utilization from a cpu

1 reply

0 recast

0 reaction

Ryan pfp

0 reply

0 recast

2 reactions

Ryan pfp

@indexsupply CAN DECODE ALL KINDS OF ABI ENCODED DATA

0 reply

3 recasts

8 reactions

Ryan pfp

I'm looking to lease a primo dwelling in SF. Criteria: high quality build in a tranquil location. I've had no luck on CL/Zillow. If anyone has a lead on such a dwelling please do let me know.

1 reply

1 recast

7 reactions

Ryan pfp

Very excited about this for a few reasons 1) My latest PG extension decodes arbitrarily complex ABI data 2) Crypto companies should accept crypto payments 3) @daimo is really good

1 reply

3 recasts

12 reactions

Ryan pfp

I'm enjoying this song https://www.youtube.com/watch?v=9by02005nXM

1 reply

0 recast

1 reaction

Ryan pfp

https://www.phoronix.com/review/amd-epyc-9965-9755-benchmarks/3 Interesting to see the comparison of the 9965 (more cores) and the 9755 (higher freq.) on ClickHouse and RocksDB tests. More cores helps random reads while higher freq. presumably helped all of CH's compression and vectorized query processing. I wonder if the CPUs have different io characteristics.

2 replies

1 recast

6 reactions

Ryan pfp

A while back I wondered if SSD vendors would start building for specific database implementation. Apparently the gods are on our side https://blocksandfiles.com/2024/10/16/kioxia-speeds-rocksdb-1-8x-with-flexible-data-placement-ssd/ https://warpcast.com/ryansmith/0x40563ad3

0 reply

1 recast

7 reactions

Ryan pfp

0 reply

0 recast

2 reactions

Ryan pfp

What a beautiful motherboard. Notice the positions of the PCIe connectors. So close to the backplane. Wow.

0 reply

1 recast

5 reactions

Ryan pfp

wow! I didn't realize AWS has a mechanism for taking consistent snapshots across EBS volumes. https://aws.amazon.com/blogs/storage/taking-crash-consistent-snapshots-across-multiple-amazon-ebs-volumes-on-an-amazon-ec2-instance/

0 reply

0 recast

1 reaction

Ryan pfp

Glad to see Go is improving JSON in its std lib https://github.com/golang/go/issues/71497

0 reply

0 recast

5 reactions

Ryan pfp

What's stopping you from processing 576 GB/s?

0 reply

0 recast

9 reactions

Ryan pfp

Went on a little tour of IPMI/BMC security discussions. A few notes - Seems more problematic at scale when you have many servers and require remote management - You don't need to worry about network security if no one can access the network (ie don't plug a cable into the management port) Schneier has a good summary post: https://www.schneier.com/blog/archives/2013/01/the_eavesdroppi.html

0 reply

1 recast

5 reactions

Ryan pfp

Have any of you had experience running SMCI? If so would you do it again?

3 replies

9 recasts

27 reactions

Ryan pfp

Fascinating to think about optimizing loops for CPUs. I wonder if PG's numeric additions could benefit from a more branchless approach https://github.com/postgres/postgres/blob/4f15759bdcddd23e874526a6b2c0ff86e0beb042/src/interfaces/ecpg/pgtypeslib/numeric.c#L637-L754 https://15721.courses.cs.cmu.edu/spring2023/slides/06-execution.pdf

0 reply

0 recast

4 reactions

Ryan pfp

I really enjoy this web site https://www.rapidtables.com/convert/number/hex-to-decimal.html

1 reply

0 recast

7 reactions

Ryan pfp

People who are really serious about coffee should mineralize their own water.

1 reply

0 recast

6 reactions

Ryan pfp

Most queries in Snowflake / Redshift scan only 100MB of data! https://www.fivetran.com/blog/how-do-people-use-snowflake-and-redshift

0 reply

1 recast

6 reactions

Ryan pfp

Excellent paper on the pitfalls of MMAP files for DBMS workloads. I've personally reached for the MMAP silver bullet and it didn't work out for me and this paper helped me understand why. Great read! A++ https://db.cs.cmu.edu/mmap-cidr2022/

2 replies

0 recast

4 reactions