til
til copied to clipboard
xluffy
You only feel happy when you know what you doing
- https://www.morling.dev/blog/insatiable-postgres-replication-slot/ - https://debezium.io/documentation/reference/connectors/postgresql.html#postgresql-wal-disk-space Fix with hearbeats table https://wolfman.dev/posts/pg-logical-heartbeats/
PostgreSQL, one such feature that distinguishes more advanced users is the `MERGE` command, **introduced in version 15 and expanded in version 17** (in beta at the time of writing this...
For MySQL, the [ON UPDATE](https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html) clause can be used to set the current timestamp when a row gets updated. Postgres does not support this feature, unfortunately. If you search for...
``` serviceAccount: name: "gh-api" create: True role: create: True rules: - apiGroups: - '' resources: - secrets verbs: - get - ``` I want to insert a new blank line...
Hai thái cực của OLAP và OLTP cũng như những thử thách, khó khăn của từng lĩnh vực https://www.crunchydata.com/blog/postgres-powered-by-duckdb-the-modern-data-stack-in-a-box
``` SELECT p.pid, now() - a.xact_start AS duration, coalesce(wait_event_type ||'.'|| wait_event, 'f') AS waiting, CASE WHEN a.query ~*'^autovacuum.*to prevent wraparound' THEN 'wraparound' WHEN a.query ~*'^vacuum' THEN 'user' ELSE 'regular' END...