/images/avatar.jpg
杂七杂八的,随手记录。

gpdb memory control

TODO 1 VMem

2 Resource Group Control

  • ResourceGroupGetQueryMemoryLimit(void) 用于获取内存限制的绝对大小 (非百分比)

2.1 Bypass

  • 绕开资源限制模式

  • Enabled when:

    • gp_resource_group_bypass is true: guc_gp.c

      1
      2
      3
      4
      5
      6
      7
      8
      9
      
      {
          {"gp_resource_group_bypass", PGC_USERSET, RESOURCES,
              gettext_noop("If the value is true, the query in this session will not be limited by resource group."),
              NULL
          },
          &gp_resource_group_bypass,
          false,
          check_gp_resource_group_bypass, NULL, NULL
      }
      
    • Or command is one of:

GPDB: Configuring Your Systems

本文为摘录(或转载),侵删,原文为: -https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-install_guide-prep_os.html#networking -https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-install_guide-prep_os.html

1 IP Fragmentation Settings

IP Fragmentation Settings

When the Greenplum Database interconnect uses UDP (the default), the network interface card controls IP packet fragmentation and reassemblies.

If the UDP message size is larger than the size of the maximum transmission unit (MTU) of a network, the IP layer fragments the message. (Refer to Networking later in this topic for more information about MTU sizes for Greenplum Database.) The receiver must store the fragments in a buffer before it can reorganize and reassemble the message.

Hash Index of PG

Table of Contents

本文为摘录(或转载),侵删,原文为: ../../../Work/pg_master/src/backend/access/hash/README

1 Hash Indexing

这个目录包含了 Postgres 的散列索引实现。其中大部分核心思想来自于 Margo Seltzer 和 Ozan Yigit 在 1991 年 1 月举行的冬季 USENIX 会议上的论文《A New Hashing Package for UNIX》。我们的内存哈希表实现(src/backend/utils/hash/dynahash.c)也依赖于相同的概念;它源自于 Esmond Pitt 编写的代码,后来又由 Margo 和其他人进行了改进。

How To Use Journalctl to View and Manipulate Systemd Logs

本文为摘录(或转载),侵删,原文为: https://www.digitalocean.com/community/tutorials/how-to-use-journalctl-to-view-and-manipulate-systemd-logs

1 Basic Log Viewing

要查看 journald 守护程序收集的日志,请使用 journalctl 命令。

当单独使用时,系统中的每个日志条目都会在翻页器(通常是 less)中显示,供您浏览。最旧的条目将显示在顶部:

Hybrid Blockchain Database Systems: Design and Performance

Table of Contents

本文为摘录(或转载),侵删,原文为: attachments/pdf/e/p1092-loghin.pdf

1 ABSTRACT

Abbrs:

  • CFT: crash fault-tolerant
  • BFT: byzantine fault-tolerant
    Byzantine Fault Tolerance (BFT) is a trait of decentralized, permissionless systems which are capable of successfully identifying and rejecting dishonest or faulty information. Byzantine fault tolerant systems have successfully solved the Byzantine Generals Problem and are robust against sybil attacks.

2 INTRODUCTION

  • 学术界出现了集成分布式数据库与区块链特性的系统

iReader & Calibre

Table of Contents

1 表现

通过 Calibre 向 iReader 中传输书籍失败,报 MTP 相关错误。

2 原因

不知道为什么,无法在设备存储空间中创建目录

3 绕过方法

  1. 用文件管理器提前创建 Books 目录 (不推荐), 或者
  2. 在 Calibre 中找到设备,选择配置,将传输目录指向已有的目录,例如 iTransfer

推荐第二种,配置过后会生成下面的配置文件 ~/.config/calibre/mtp_devices.json

New Wine in an Old Bottle: Data-Aware Hash Functions for Bloom Filter

Table of Contents

本文为摘录(或转载),侵删,原文为: attachments/pdf/4/p1924-bhattacharya.pdf

FPR: Fault Positive Rate

Partitioned Bloom Filter ,

  • 方法

    • 将 BloomFilter 划分成 segments
    • 每个 segment 使用简单的、基于投影的哈希函数,
      • 函数通过数据计算得来
  • 效果

    • 减少误报 (两个数量级)
    • 相同误报率的话,提升 50% 的压缩率

1 INTRODUCTION

  • Projection Hash Bloom Filter (PHBF)