# PostgreSQL - [Postgres large JSON value query performance](x-devonthink-item://B0D302E1-5BCD-4A65-9F83-416E3082F686) - [Postgres large sub-string query performance](x-devonthink-item://7DF531CE-370C-46C9-A2F6-04E8F1A29D95) - [query planner improvements in PG16](https://www.citusdata.com/blog/2024/02/08/whats-new-in-postgres-16-query-planner-optimizer/) - [PG is enough](https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f06dbb) - links to solutions using postgres - scheduled jobs - message queues - full text - vectors - timeseries - [db-fiddle](https://www.db-fiddle.com/) - [pglocks](https://pglocks.org/) - - > This tool shows all commands and locks in postgres. If you select a command, it lists the locks that it acquires, commands that conflicts with it and commands that are allowed to run concurrently with it (with no conflict or blocking). If you select a lock, it lists commands that acquire the lock and what are the other conflicting locks. ## Interesting Projects ### pgproxy [link](https://github.com/tailscale/tailscale/tree/main/cmd/pgproxy) [[tailscale]] TLS-proxy for [[PostgreSQL]] ### DB-fiddle examples - updating `updated_at` https://www.db-fiddle.com/f/4jyoMCicNSZpjMt4jFYoz5/12250 ### [[eBPF]] lock tracer - https://github.com/jnidzwetzki/pg-lock-tracer