- 博客(1215)
- 资源 (5)
- 收藏
- 关注
原创 etcdserver: mvcc: database space exceeded
错误信息默认存储大小为2GB,如果不启用压缩,达到后就会出现这个错误提示。
2023-05-05 10:25:07
31
1
原创 powerdns 系列之二 PowerDNS Authoritative Server
PowerDNS Authoritative Server 权威服务器,直接查询数据库去尝试解析,数据库中若不存在此记录,则直接返回空结果。
2023-01-19 10:39:36
1447
原创 aws aurora postgresql 数据库 rds.extension、shared_preload_libraries 参数值
shared_preload_libraries
2022-11-08 21:50:01
26
原创 kafka + sink connect + confluent + elasticsearch 最佳参数实践
confluent ,elasticsearch
2022-07-21 21:08:57
40
转载 初始化参数OPEN_CURSORS的理解加深
以前一直有些迷惑,一直以为v$open_cursor里查询出来就是当前open的cursor,google收藏了一些讨论得比较深入的帖,比如说这里: 。[@more@]今天看到Natalka Roshak写的一篇关于open_cursors及session_cached_cursors的文章,顿时一目了然,参见:,摘录部分精彩内容如下:SESSION_CACHED_CURSORS sets the number of cached closed cursors each session can have
2022-04-06 14:31:59
516
转载 PostgreSQL的WAL
<<PostgreSQL的WAL(1)–Buffer Cache>><<PostgreSQL的WAL(2)–Write-Ahead Log>><<PostgreSQL的WAL(3)–Checkpoint>><<PostgreSQL的WAL(4)–WAL创建和调优>>
2022-03-09 11:27:16
92
原创 ignore_checksum_failure
SELECT * FROM tmp_t0;WARNING: page verification failed, calculated checksum 23222 but expected 50884ERROR: invalid page in block 0 of relation base/16386/24890但是,如果无法从备份还原数据,我们该怎么办? 当然,ignore_checksum_failure参数使您能够尝试读取表,但有可能损坏数据。SET ignore_checksum_
2022-03-09 10:13:38
213
转载 如何遏制PostgreSQL WAL的疯狂增长
http://blog.chinaunix.net/uid-20726500-id-5766987.html
2022-03-08 14:29:07
174
转载 12c: USE_SID_AS_SERVICE_listener_name
In an Oracle 12c container database, the client must specify a service name in order to connect to the PDB. Many Database clients with earlier releases of Oracle Database might have hard-coded connect descriptors to use SID to connect to the database. Now
2022-03-03 10:07:17
229
转载 Indexes in PostgreSQL — 10 (Bloom)
In the previous articles we discussed PostgreSQL indexing engine and the interface of access methods, as well as B-trees, GiST, SP-GiST, GIN, RUM, and BRIN. But we still need to look at Bloom indexes.BloomGeneral conceptA classical Bloom filter is a dat
2022-03-01 11:47:54
100
转载 Indexes in PostgreSQL — 9 (BRIN)
In the previous articles we discussed PostgreSQL indexing engine, the interface of access methods, and the following methods: B-trees, GiST, SP-GiST, GIN, and RUM. The topic of this article is BRIN indexes.BRINGeneral conceptUnlike indexes with which we
2022-03-01 11:30:51
115
转载 Indexes in PostgreSQL — 8 (RUM)
We have already discussed PostgreSQL indexing engine, the interface of access methods, and main access methods, such as: hash indexes, B-trees, GiST, SP-GiST, and GIN. In this article, we will watch how gin turns into rum.RUMAlthough the authors claim th
2022-03-01 10:58:11
98
转载 Indexes in PostgreSQL — 7 (GIN)
We have already got acquainted with PostgreSQL indexing engine and the interface of access methods and discussed hash indexes, B-trees, as well as GiST and SP-GiST indexes. And this article will feature GIN index.GIN“Gin?.. Gin is, it seems, such an Amer
2022-02-28 19:29:21
206
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人