xluffy

Using recent improvements of the PostgreSQL database server. Most notably, besides the use of background workers,`pg_squeeze` uses logical decode instead of triggers to capture concurrent changes `pg_repack`. https://github.com/cybertec-postgresql/pg_squeeze

In short, BlurHash takes an image, and gives you a short string (only 20-30 characters!) that represents the placeholder for this image. You do this on the backend of your...

``` > find . -name '.?*' > ls -ld .?* ```

You can see what's in the PostgreSQL buffer cache using the pg_buffercache module. I've done a presentation called "[Inside the PostgreSQL Buffer Cache](https://2ndquadrant.com/media/pdfs/talks/InsideBufferCache.pdf)" that explains what you're seeing, and I...

TLDR: Bắt gói tin và gửi gói tin để kill undead queries https://engineering.zalando.com/posts/2015/04/how-to-fix-what-you-cant-kill-undead-postgresql-queries.html

Debezium provides a ready-to-use application that streams change events from a source database to messaging infrastructure like Amazon Kinesis, Google Cloud Pub/Sub, Apache Pulsar, Redis (Stream), or NATS JetStream. **For...

- 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...