1 解决 calibre 导入书籍和传输书籍不是中文名称问题 2 我的解决方法 2.1 追加 本文为摘录，原文为： https://mp.weixin.qq.com/s?__biz=MzA5MTgxNzM0Nw==&mid=2653286264&idx=1&sn=78ffdd914a3863f0b3927485e669bd98&chksm=8ba7db94bcd05282c10916297526edefb001f4b88ef18434c85e20d44a784893a1b91b80df37&mpshare=1&scene=1&srcid=0410rJQbgLUkbG2wSAoTpbln&sharer_shareinfo=6d065c71e8d859f972c14e5e0361382b&sharer_shareinfo_first=6d065c71e8d859f972c14e5e0361382b#rd 1 解决 calibre 导入书籍和传输书籍不是中文名称问题 去官网下载最新...
1 Q 2 A: 3 Further more 本文为摘录，原文为： https://superuser.com/questions/77504/how-to-strip-audio-streams-from-an-mkv-file 1 Q 我一直在尝试从一个 MKV（Matroska）文件中删除不需要的音频流。我这样做的原因是为了避免在 Windows Media...
1 What is Random Page Cost? 2 Diving Deeper 3 Seeing is Believing: Before and After Examples 3.1 Before (RPC = 4.0): 3.2 After (RPC = 1.1): 4 can perform it on a per query/connection basis 本文为摘录，原文为： https://postgr.es/p/6oe 最近我在 Postgres 中处理一些查询，发现它要么选择不使用...
1 Failed to login as normal user 1 Failed to login as normal user passwd 中，用户使用的 shell ， 必需是包含在 /etc/shells 里面的，否则会无法登录，哪怕密码没有问题。
1 pin_lock 概述 2 相关数据结构 2.1 struct spinlock 2.2 struct qnode 3 相关函数 3.1 初始化函数 3.2 上锁函数 3.3 解锁函数 3.4 尝试获取锁函数 3.5 判断上锁状态 3.6 还可以直接使用 raw_spinlock_t 和与其配套的一组...
1 Interprocedural optimization 2 GCC function suffixes 本文为摘录，原文为： https://people.redhat.com/~jolawren/klp-compiler-notes/livepatch/compiler-considerations.html 1 Interprocedural optimization 函数内联可能是影响动态修补最常见的编译器优化。在一个简单的例子中，内联将原始代码转换为： foo() { ... [ foo...
1 HTAP 架构原理 2 分布式优化器 3 算子并行化 4 消除数据倾斜问题 5 SQL 级别弹性扩展 6 事务一致性 7 TPC-H 性能：加速比 8 TPC-H 性能：和传统 MPP 数仓对比 9 分布式执行加...
1 A Universal Method 2 Debian / Ubuntu 3 Fedora / Rocky Linux / AlmaLinux 4 Arch Linux 本文为摘录，原文为： https://linuxiac.com/how-to-find-linux-os-installation-date/ 1 A Universal Method 首先，我们必须澄清一点，在 Linux 中没有专门的设置、变量、日志文件条目或类似的东...
本文为摘录，原文为： attachments/pdf/6/p2134-kim.pdf 本文介绍了一种称为 ABC（Attributed Bipartite Co-clustering 双向联合集聚归因算法）的问题， 它对于一个具有属性的二分图进行聚类。对...
1 ABSTRACT 2 INTRODUCTION 3 PRELIMINARIES AND BACKGROUND 4 EVALUATION PLAN 4.1 CardEst Algorithms 本文为摘录，原文为： attachments/pdf/2/p752-zhu.pdf 1 ABSTRACT we compare the effectiveness of CardEst methods in a real DBMS We establish a new benchmark for CardEst, which: contains a new complex realworld dataset STATS and a diverse query workload STATS-CEB. We integrate multiple most representative CardEst methods into PostgreSQL, and evaluate...
1 Threads (Tasks (threads) versus processes) 1.1 cgroup v2 线程限制 1 Threads (Tasks (threads) versus processes) cgroup v1 可以单独操作进程中的线程, man cgroups : In cgroups v1, a distinction is drawn between processes and tasks. In this view, a process can con‐ sist of multiple tasks (more commonly called threads, from a user-space perspective,...
1 INTRODUCTION 2 BACKGROUND 2.1 Apache AsterixDB 本文为摘录，原文为： attachments/pdf/f/p2085-alkowaileet.pdf 这篇论文探讨了文档存储数据库系统的数据模型灵活性限制其在列式关系数据库中进行分析工作负载 的表现。作者提出...
1 Hash & TapeSet 2 Slot & tuple 1 Hash & TapeSet class LogicalTapeSet { + BufFile pfile + SharedFileSet fileset + int worker + long nBlocksAllocated + long nBlocksWritten + long nHoleBlocks + bool forgetFreeSpace + long freeBlocks + long nFreeBlocks + Size freeBlocksLen + bool enable_prealloc } class LogicalTape { + LogicalTapeSet tapeSet + bool writing + bool frozen + bool dirty + long firstBlockNumber + long curBlockNumber + long nextBlockNumber + long offsetBlockNumber + char buffer + int buffer_size + int max_size + int pos + int nbytes + long prealloc + int nprealloc + int prealloc_size } class BufFile { + int numFiles + File files + bool isInterXact + bool dirty + bool readOnly + FileSet fileset + const name + ResourceOwner resowner + int curFile + off_t curOffset + int pos + int nbytes + PGAlignedBlock buffer } LogicalTapeSet *-- BufFile class HashAggSpill { + int npartitions + LogicalTape partitions + int64 ntuples + uint32 mask + int shift + hyperLogLogState hll_card } HashAggSpill *-- LogicalTape LogicalTape - LogicalTapeSet 2 Slot & tuple class TupleTableSlot { + NodeTag type + int tts_flags + AttrNumber tts_nvalid + const tts_ops + TupleDesc tts_tupleDescriptor + int tts_values + int tts_isnull + int tts_mcxt + ItemPointerData tts_tid + int tts_tableOid } class MinimalTupleData { + int t_len + char mt_padding + int t_infomask2 + int t_infomask + int t_hoff + int t_bits } class HeapTupleHeaderData { + union t_choice + ItemPointerData t_ctid + int t_infomask2 + int t_infomask + int t_hoff + int t_bits } class union { + HeapTupleFields t_heap + DatumTupleFields t_datum } HeapTupleHeaderData *-- union class MinimalTupleTableSlot { + TupleTableSlot base + HeapTuple tuple + MinimalTuple mintuple + HeapTupleData minhdr + int off } class HeapTupleData { + int t_len + ItemPointerData t_self + int t_tableOid + HeapTupleHeader t_data } class VirtualTupleTableSlot { + TupleTableSlot base + char data } class HeapTupleTableSlot { + TupleTableSlot base + HeapTuple tuple + int off + HeapTupleData tupdata } class BufferHeapTupleTableSlot { + HeapTupleTableSlot base + Buffer buffer } TupleTableSlot <|-- MinimalTupleTableSlot TupleTableSlot <|-- VirtualTupleTableSlot TupleTableSlot <|-- HeapTupleTableSlot HeapTupleTableSlot <|-- BufferHeapTupleTableSlot MinimalTupleTableSlot *-- MinimalTupleData HeapTupleTableSlot *-- HeapTupleData HeapTupleData *-- HeapTupleHeaderData
本文为摘录，原文为： https://github.com/powa-team/powa Workload Analyzer.
1 Hash Indexing 2 Page Addressing 本文为摘录，原文为： ../../../Work/pg_master/src/backend/access/hash/README 1 Hash Indexing 这个目录包含了 Postgres 的散列索引实现。其中大部分核心思想来自于 Margo Seltzer 和 Ozan Yigit 在 1991 年 1 月举行的冬季 USENIX 会议上的论文...
1 #9: Optimizations past their prime 1.1 Best practices 1.2 #21: Improving the efficiency of your regular expressions 本文为摘录，原文为： https://abseil.io/fast 1 #9: Optimizations past their prime 1.1 Best practices – 可能的情况下编写清晰、惯用的代码 Prefer writing clear, idiomatic code whenever possible. It is not only easier to read and...
1 Introduction 2 Why pgAudit 3 Usage Considerations 4 Settings 4.1 pgaudit.log 4.2 pgaudit.log_catalog 5 Session Audit Logging 6 Object Audit Logging 7 Format 本文为摘录，原文为： https://github.com/pgaudit/pgaudit#readme 1 Introduction PostgreSQL 审计扩展（pgAudit）通过标准的 PostgreSQL 日志记录功能提供详细的会话...
1 Introduction 1.1 Virtual IDs 1.2 Block-oriented and vectorized processing \\ 1.3 Late materialization 晚期物化 1.4 Column-specific compression 1.5 Direct operation on compressed data 1.6 Efficient join implementations 1.7 Redundant representation of individual columns in dif- ferent sort orders 1.8 Database cracking and adaptive indexing 1.9 Efficient loading architectures 2 Column-store internals and advanced techniques 2.1 Vectorized Processing 向量化处理 2.2 Compression 2.3 Operating...
1 Relfilenode of ordinary table 2 Relfilenode of Nail tables 3 Nail table Relfilenode storage mechanism 4 Summary 本文为摘录，原文为： https://www.highgo.ca/2021/01/12/the-mapping-of-oid-and-relfilenode-in-pg/ A table in PostgreSQL has a relfilenode value, which specifies the file name of the table on disk (except foreign table and partition table). In general, this value can be found in the relfilenode field of the pg_class table, but there...
1 ABSTRACT 2 BACKGROUND 2.1 Design Overview 3 DATA MODEL 3.1 Projections 3.2 Join Indexes 3.3 Prejoin Projections 3.4 Encoding and Compression 3.5 Partitioning 3.6 Segmentation: Cluster Distribution 3.7 Read and Write Optimized Stores 4 TUPLE MOVER 5 QUERY EXECUTION 5.1 Query Operators and Plan Format 5.2 Query Optimization 本文为摘录，原文为： attachments/pdf/3/The Vertica Analytic Database- C-Store 7 Years Later (p1790_andrewlamb_vldb2012).pdf 1 ABSTRACT...