til
til copied to clipboard
xluffy
You only feel happy when you know what you doing
- https://www.cybertec-postgresql.com/en/blog/ - https://www.enterprisedb.com/blog - https://www.depesz.com/ - https://www.crunchydata.com/blog - https://www.timescale.com/blog/ - https://ongres.com/blog/ - https://www.scalingpostgres.com/ - https://www.highgo.ca/blog/ - https://www.postgresql.fastware.com/blog/ - https://pganalyze.com/blog
 https://www.highgo.ca/2020/06/18/an-overview-of-postgresql-backend-architecture/
LZ4 TOAST compression https://www.postgresql.fastware.com/blog/what-is-the-new-lz4-toast-compression-in-postgresql-14
  https://www.highgo.ca/2024/01/26/a-comprehensive-overview-of-postgresql-query-processing-stages/
Bitmap Scans are always in (at least) two nodes. First (lower level) there is **Bitmap Index Scan**, and then there is **Bitmap Heap Scan**. How does it work? Let's assume...
> Babelfish for PostgreSQL is an open source project available under the Apache 2.0 and PostgreSQL licenses. It provides the capability for PostgreSQL to understand queries from applications written for...
https://paquier.xyz/postgresql-2/postgres-14-monitoring-copy/
https://aphyr.com/posts/367-why-is-jepsen-written-in-clojure
Block CIDRs in Ingress nginx with `block-user-agents` ``` ginkgo.It("should block CIDRs defined in the ConfigMap", func() { f.UpdateNginxConfigMapData("block-cidrs", "172.16.0.0/12,192.168.0.0/16,10.0.0.0/8") f.WaitForNginxConfiguration( func(cfg string) bool { return strings.Contains(cfg, "deny 172.16.0.0/12;") && strings.Contains(cfg,...
Notes: - The planner's behavior doesn't depend on the actual resources available such as CPU or RAM. Nor does it depend on OS, FS or their settings. - The value...