Рет қаралды 272
[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try KZfaq's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss transaction_timeout (a recently committed addition for Postgres 17) - what it's for, how to get around not having it already, and whether it will replace the need to set statement_timeout globally in future.
Here are some links to things they mentioned:
* transaction_timeout (devel docs) www.postgresql.org/docs/devel...
* Commit: git.postgresql.org/gitweb/?p=...
* Mailing list thread: www.postgresql.org/message-id...
* Hacking Postgres session on Postgres TV where work started kzfaq.infoWLoMpg8A...
* Our first ever episode, on slow queries and slow transactions postgres.fm/episodes/slow-que...
* statement_timeout (v7.3) www.postgresql.org/docs/curre...
* idle_in_transaction_session_timeout (v9.6) www.postgresql.org/docs/curre...
* idle_session_timeout (v14) www.postgresql.org/docs/curre...
~~~
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 postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
Check out postgres.fm to subscribe to the audio-only podcast, to see the transcript, guest profiles, and more.