til
til copied to clipboard
xluffy
You only feel happy when you know what you doing
- https://eli.thegreenplace.net/ - https://bitfieldconsulting.com/golang - https://benhoyt.com/writings/
https://momjian.us/main/writings/pgsql/features.pdf
``` SELECT add_retention_policy('conditions', INTERVAL '24 hours'); ``` https://www.timescale.com/blog/pg_partman-vs-hypertables-for-postgres-partitioning/
``` WITH keke AS ( SELECT '{"a":1,"b":2}'::jsonb AS attribute UNION ALL SELECT '{"a":1,"c":2}'::jsonb AS attribute UNION ALL SELECT '{"b":1,"c":2}'::jsonb AS attribute ) --SELECT attribute FROM keke; SELECT CASE WHEN attribute->>'c'...
The Ugly Duckling of index types https://hakibenita.com/postgresql-hash-index > When to use B+ Tree vs Hash Index > If you are 100% certain that a column will only ever need to...
``` psql=# selec psql=# select psql=# \set COMP_KEYWORD_CASE upper psql=# selec psql=# SELECT ``` or setting in `psqlrc` ``` \set COMP_KEYWORD_CASE upper ``` https://hakibenita.com/postgresql-unknown-features#autocomplete-reserved-words-in-uppercase
https://ottertune.com/blog/run-postgresql-analyze-to-fix-a-slowdow-in-db/ 
Kong Gateway is built on top of OpenResty/Nginx, which is a **multi-process single-threaded architecture.** **To collect and aggregate metrics from different processes**, we implement the Prometheus plugin with **shared memory.**...
> The maximum value imposed by the kernel is the maximum value which can be stored in a variable of type long in C on your architecture. [7dc5065a477db1c64481eedd/tools/include/uapi/Linux/fs.h#L100](https://github.com/torvalds/linux/blob/1ef6663a587ba3e57dc5065a477db1c64481eedd/tools/include/uapi/linux/fs.h#L100)