OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
GPL-2.0 License
1 https://pan.baidu.com/s/1Q5u5NSrb0gL5-psA9DCBUQ (5nox , )
22021-PG - 32021-DB - 42020-PostgreSQL - 52020-PostgreSQL+MySQL - 62019-PostgreSQL 2 - DBA 72017-PostgreSQL - 82019-PG - DBA 92019-OraclePostgreSQL - DBA 102021-Ask - DBA 112018-PG - 122018-POLARDB for Oracle|RDS for PPAS 132022-5,PG - 1 - 142023-PostgreSQL|PolarDB 152023-PostgreSQL|PolarDB 162024-PolarDB|PostgreSQL &DBA 172023-PostgreSQL Docker ARM64, 182023-PostgreSQL Docker AMD64, 192024-
1Oracle DBA + PostgreSQL 2PostgreSQLGreenplum +108 3PostgreSQL - 4PostgreSQL - 5PostgreSQL DBASQL 6PostgreSQL 7 8PostgreSQL - () 9 - - 10(PostgreSQL,MySQL,Oracle) 11PostgreSQL - 1 PostgreSQL 12PostgreSQL - 2 Linux 13PostgreSQL - 3 14PostgreSQL - 4 SQL 15PostgreSQL - 5 16PostgreSQL - 6 17PostgreSQL - 7 18PostgreSQL - 8 PostgreSQL 19PolarDB PostgreSQL+PolarDB+
1 2 1 - 3PG - 4PostgreSQL 5PostgreSQL {} 6[] PostgreSQL\Greenplum TODO 7[] PostgreSQL\Greenplum CustomerTODO 8PG? 9 10 - PG - openapi 11[] 12 - PostgreSQL (202005) 13, PG 14, , , PG 15PostgreSQL 16 - 24 17CxO 15
PG | PG | digoal |
---|---|---|
pic | pic | image.png |
, , .
(), , issue,
digoal's|PostgreSQL|| ---|---|---|--- 1 | 2 | 3 | 4 ,, 5 | 6 | 7 | 8 9 | 10 | 11 OLAP(MPP...) | 12 13 | 14 | 15 | 16 HTAP 17 | 18 | 19 | 20 GIS 21 Oracle | 22 | 23 Benchmark | 24 25 DaaS | 26 | 27 () | 28 29 | 30 | 31 | 32 33 | 34 | 35 | 36
7*24
IT - AI agent ? ?
LLama3:8b
, ollama
/usr/libexec/bootpd -D
OR to ANY
ALTER TABLE ... MERGE|SPLIT PARTITION
... command
--transaction-size=N
N
MERGE ... WHEN NOT MATCHED BY SOURCE
pg_replication_slots.inactive_since
random(min, max)
http/https``socks5
all_proxy http_proxy https_proxy
alter system ``postgresql.auto.conf
DEFAULT
in ALTER TABLE .. SET ACCESS METHOD
--copy-file-range
option to pg_upgrade
trusted.gpg
keyring (/etc/apt/trusted.gpg
), see the DEPRECATION section in apt-key(8)
for details
-L/-R/-D
,,socks5
joinkey&value
hash and stored into memory
pg_create_logical_replication_slot(... failover = true|false ...)
pgbench: Add \syncpipeline
\
create extension duckdb_fdw
: could not load library...undefined symbol...
pg_get_wal_summarizer_state()
pg_wal/summaries pidwal
PQchangePassword()
, alter userSQLlogpg_stat_statements
alter table ... ALTER COLUMN ... SET EXPRESSION AS (express)
%TYPE
%ROWTYPE
pg_replication_slots
.conflict_reason
time Command
: Real, User and Sys process time statistics
0~``~1
? ?
local_blk_{read|write}_time
I/O timing statistics for local blocks
struct.*
docker system prune -a --force
docker builder prune
pg_stat_io
as well.
pg_stat_*
Count updates that move row to a new page, fillfactor
like '%xxx%'
GENERATED ALWAYS AS () VIRTUAL
#n
z->z^2+c
pg_read_[binary_]file (filename, missing_ok)
, .
--compress WHERE-zstd:workers=N
like
~
?
order by
?
pg_cancel_backend, pg_terminate_backend
?
idle in transaction|idle
? ?
truncate
option to subscription commands - truncate
~ ~* !~
count(*) group by order by count(*) desc limit x
) (use topn)
2016-11-24 10:57:04.081798
~ 2016-11-24 11:10:13.201455
2016-11-24 10:51:14.744512
~ 2016-11-24 10:57:04.081798