winter-loo - 博客园

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 winter-loo 阅读(9) 评论(0) 推荐(0)

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 winter-loo 阅读(9) 评论(0) 推荐(0)

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 winter-loo 阅读(15) 评论(0) 推荐(0)

[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 winter-loo 阅读(26) 评论(0) 推荐(0)

obsidian-excalidraw-plugin 折腾日记

摘要： 1 起因是我在 Obsidian 里用 excalidraw 画了几十帧关于 PG 中 window function 的实现。每一帧按顺序播放的话，就可以形成定格动画的效果。 obsidian 里的 excalidraw 也可以使用插件。为了形成定格动画的播放效果，我更改了 SlideShow 插阅读全文

posted @ 2024-08-10 21:29 winter-loo 阅读(507) 评论(0) 推荐(0)

internals of window function implementation

摘要： kinds of frame definition implementation https://ldd.cool/pdf/windowagg.pdf 阅读全文

posted @ 2024-08-10 20:56 winter-loo 阅读(13) 评论(0) 推荐(0)

what is a junk attribute

摘要： From comments of struct JunkFilter: A junk attribute is an attribute in a tuple that is needed only for storing intermediate information in the execut 阅读全文

posted @ 2024-07-26 17:27 winter-loo 阅读(17) 评论(0) 推荐(0)

randomly gathered good presentations of PG

摘要： https://www.postgresql.eu/events/pgconfeu2017/schedule/session/1585-be-pro-activ-on-postgresql-performance/ https://www.postgresql.eu/events/pgconfeu2 阅读全文

posted @ 2024-07-20 03:38 winter-loo 阅读(13) 评论(0) 推荐(0)

what is NamedTupleStore?

摘要： What NamedTuplestore 按字面意思理解，就是一个有名字的 tuplestore, 那估计就不是一个正常的表。根据 PostgreSQL 的官方叫法，NamedTuplestoreScan 对应的表称为 Ephemeral Named Relation，中文翻译为短暂的命名关系. 阅读全文

posted @ 2024-07-08 09:51 winter-loo 阅读(57) 评论(0) 推荐(0)

[code notes] storage of a temporary table

摘要： One sentence summary A temporary table could reside within a temporary tablespace, utilizing a temporary name in a temporary schema or namespace. More 阅读全文

posted @ 2024-06-28 16:39 winter-loo 阅读(25) 评论(0) 推荐(0)

ldd.cool

导航

公告