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...
1 INTRODUCTION 2 DESIGN AND METHODOLOGY 本文为摘录，原文为： attachments/pdf/6/p2613-guagliardo.pdf 1 INTRODUCTION NULL 用于表示不完整的数据 2 DESIGN AND METHODOLOGY
本文为摘录，原文为： https://mp.weixin.qq.com/s/xf7qb4oAVHyi4_U32FSKPA
本文为摘录，原文为： http://www.ruanyifeng.com/blog/2023/05/weekly-issue-254.html 大家可能听说过"水桶原理"：水桶的容量由最短的那块木板决定。 它的意思是，某些系统的关键，不在于发展...