Hussein Nasser (@hnasr)

Connection pool helps with unbounded number requests. But watch out for bad defaults. When a frontend connects to a reverse proxy (load balancer, api gateway, cdn etc.) and sends a request, the RP turns around and establishes a connection to the origin backend and forwards the request to the back...

Postgres runs on port 5432, this is the responsibility of the Post master process. However did you know that listening socket isn’t created until another process finish running first? That is startup process (ST), responsible for WAL redo when the database crashes. You cannot allow clients to c...

Postgres just got even faster Like most databases, Postgres work with fixed size pages. Those pages are 8K in size, each page will have the rows, or index tuples and a fixed header. The pages are just bytes in files and they are read and cached in the buffer pool. If a table has 100 pages, to do a...