false sharing in Rust
摘要：How to optimize the program below to run faster? use std::{thread, sync::Arc}; use std::sync::atomic::AtomicU64; struct Block { d1: AtomicU64, } fn wo
阅读全文
posted @ 2024-08-26 03:11
08 2024 档案
notes of extendible hash table
摘要：References https://www.geeksforgeeks.org/extendible-hashing-dynamic-approach-to-dbms/ examples walkthrough in detail https://medium.com/@redixhumayun/
阅读全文
posted @ 2024-08-22 10:39
opengauss 初折腾日记
摘要：1 起因是想玩玩 opengauss 的回收站功能。结果根据 opengauss 官方网站，根本试玩不了。 想从源码编译安装 opengauss，结果官方网站文档又不行！ 最后还是靠非官方的这篇文章才能安装成功。 2 根据官网描述，需要在 postgresql.conf 里新增 enable_rec
阅读全文
posted @ 2024-08-19 22:19
[tokio] Runtime 初始化
摘要：demo #[tokio::main] async fn main() { println!("Hello world"); } Equivalent code not using #[tokio::main] fn main() { tokio::runtime::Builder::new_mul
阅读全文
posted @ 2024-08-18 23:00
size of rust closure
摘要：principle https://doc.rust-lang.org/reference/types/closure.html?highlight=fnonce#closure-types demo 1 fn f<F : FnOnce() -> String> (g: F) { println!(
阅读全文
posted @ 2024-08-18 04:13
pg_depend
摘要：(classid,objid,objsubid) depends on (refclassid,refobjid,refobjsubid). -- which objects does relation 88088 depends on select * from pg_depend where c
阅读全文
posted @ 2024-08-15 21:22
Oracle data dictionaries
摘要：System Table Name Brief Description Related Views SYS.OBJ$ Contains information about all database objects USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS SYS.
阅读全文
posted @ 2024-08-14 14:21
[pg basics] sig_atomic_t
摘要：How does sig_atomic_t actually work? Key Takeways: sig_atomic_t is not an atomic data type used in the context of a signal handler An integral type th
阅读全文
posted @ 2024-08-13 10:45
obsidian-excalidraw-plugin 折腾日记
摘要：1 起因是我在 Obsidian 里用 excalidraw 画了几十帧关于 PG 中 window function 的实现。每一帧按顺序播放的话，就可以形成定格动画的效果。 obsidian 里的 excalidraw 也可以使用插件。为了形成定格动画的播放效果，我更改了 SlideShow 插
阅读全文
posted @ 2024-08-10 21:29
internals of window function implementation
摘要：kinds of frame definition implementation https://ldd.cool/pdf/windowagg.pdf
阅读全文
posted @ 2024-08-10 20:56
