Connections | Postgres.FM 061 |
[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss connections — the options, security and performance tradeoffs, and a few other things to be aware of.
Here are some links to some things they mentioned:
Episode on connection poolers https://postgres.fm/episodes/connecti...
listen_addresses https://www.postgresql.org/docs/curre...
SSLMODE Explained (blog post by Andrew Kane) https://ankane.org/postgres-sslmode-e...
pg_hba.conf https://www.postgresql.org/docs/curre...
Timing a query (blog post by Bruce Momjian) https://momjian.us/main/blogs/pgblog/...
How to connect (blog post by Lætitia Avrot) https://mydbanotebook.org/post/cant-c...
Improving Postgres Connection Scalability: Snapshots (blog post by Andres Freund) https://techcommunity.microsoft.com/t...
idle_session_timeout https://www.postgresql.org/docs/curre...
Do you vacuum everyday? (talk by Hannu Krosing) • Hannu Krosing. Do you vacuum #Postgre...
Don’t use now() with pg_stat_activity (tweet by Nikolay) / 1664981076014690304
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.