winslett
Postgres Calculations and the Ambiguity of Null
Postgres 19: How Our Advice Has Changed Since We Wrote It
How to Read Postgres Explain: A Guide to Scan Types
British Colombia, Time Zones, and Postgres
My go-to golf philosophy book is "Cheng Hsin: The Principles of Effortless Power":
> To relax, you must surrender your mind-even the notion that you have a mind. You will find that relaxing your mind is the same thing as relaxing your body. There should be no separation between your mind's activity and your feeling-awareness of bodily sensations and impulses. Feel yourself letting go so that your body isn't "held" so much--this requires doing the same thing with your mind. When you relax your tissues, nervous system, organs, the muscles around your organs, every-thing, then the energy will flow. It is this very relaxation that allows for the energy, or feeling-attention inherent in your body-being, to circulate, develop, and be utilized.
Don't know how this affects daily writing ;)
Pg_parquet v0.4.0: Google Cloud Storage and HTTPS storage
Ask HN: Where are developers hanging out?
Conferences seem dead. Meetups deem dead. Where are developers learning from others?
Name Collision of the Year: Vector
The PostgreSQL extension ABI issue in the latest patch release
The Future of Postgres?
Postgres Tips
You only need 12 slides to fundraise for your startup
Postgres' Clever Query Planning System
Postgres Indexing: When Does Brin Win?
We Fused DuckDB into Postgres with Crunchy Bridge for Analytics
Postgres Performance Boost: Hot Updates and Fill Factor
Postgres Row Level Security – interactive tutorial
Postgres and Citus and Partman, Your IoT Database
Postgres 16 – JSON Updates
Integer Overflow in Postgres
SELECT * FROM A, LATERAL (SELECT * FROM B ORDER BY a.embedding <-> b.embedding LIMIT 2) AS closest_in_b ORDER BY A.id;
It’s going to have so-so performance. So, don’t hose your production server. Create a vector index on b.embedding. HNSW will be nice for this use case.