til
til copied to clipboard
xluffy
You only feel happy when you know what you doing
- https://pranitha.rs/posts/rust-ipc-ping-pong/ - https://3tilley.github.io/posts/simple-ipc-ping-pong/
``` do $do$ declare i int; begin for i in 0..99 loop execute format( $sql$ create table partitioned_table_%s partition of partitioned_table for values from (%s) to (%s) $sql$, i, i...
It is possible to configure streaming replication with a delay using`recovery_min_apply_delay`. **However, there are a few pitfalls regarding replication slots, hot standby feedback, and others that one needs to be...
[Better Encrypted Group Chat](https://blog.trailofbits.com/2019/08/06/better-encrypted-group-chat/)
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...
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...