xluffy

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

- LogBucket, storage pricing: **$0.50/GiB** - GCS thì giá sẽ phức tạp hơn: - Standard storage: **$0.02/GB** (với Region) hoặc **$0.022/GB** (dual region) -> tức là về mặt storage, LogBucket...

Sometimes, you want to connect via URI `postgres` user, same with switching to `postgres` user from the command line ``` postgres:///?host=/var/run/postgresql/&sslmode=disable&port=5433 postgresql:///?host=/var/run/postgresql/&sslmode=disable&port=5433 ```

``` \COPY (SELECT * FROM items LIMIT 10) TO '/tmp/items.csv' WITH (FORMAT CSV, HEADER, FORCE_QUOTE *); ```

> One of these nifty features that I want to share about is the`auth_user` and`auth_query` combo that serves as an alternative to the default authentication process that uses `userlist.txt `....