Re: Something is wrong with wal_compression
От
Andres Freund
Тема
Re: Something is wrong with wal_compression
Дата
Msg-id
20230128025758.h47sg4cpgjz4v3s2@awork3.anarazel.de
Ответ на
Re: Something is wrong with wal_compression (Thomas Munro)
Список
Дерево обсуждения
Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Re: Something is wrong with wal_compression Justin Pryzby <pryzby@telsasoft.com>
Re: Something is wrong with wal_compression Justin Pryzby <pryzby@telsasoft.com>
Re: Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Re: Something is wrong with wal_compression Andrey Borodin <amborodin86@gmail.com>
Re: Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Re: Something is wrong with wal_compression Thomas Munro <thomas.munro@gmail.com>
Re: Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Re: Something is wrong with wal_compression Andrey Borodin <amborodin86@gmail.com>
Re: Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Re: Something is wrong with wal_compression Michael Paquier <michael@paquier.xyz>
Re: Something is wrong with wal_compression Thomas Munro <thomas.munro@gmail.com>
Re: Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Re: Something is wrong with wal_compression Thomas Munro <thomas.munro@gmail.com>
Re: Something is wrong with wal_compression Andres Freund <andres@anarazel.de>
Re: Something is wrong with wal_compression Maciek Sakrejda <m.sakrejda@gmail.com>
Re: Something is wrong with wal_compression Laurenz Albe <laurenz.albe@cybertec.at>
Re: Something is wrong with wal_compression Michael Paquier <michael@paquier.xyz>
Re: Something is wrong with wal_compression Andres Freund <andres@anarazel.de>
Re: Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Re: Something is wrong with wal_compression Andres Freund <andres@anarazel.de>
Re: Something is wrong with wal_compression Andres Freund <andres@anarazel.de>
Re: Something is wrong with wal_compression Andrey Borodin <amborodin86@gmail.com>
Re: Something is wrong with wal_compression Andres Freund <andres@anarazel.de>
Re: Something is wrong with wal_compression Thomas Munro <thomas.munro@gmail.com>
Re: Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Re: Something is wrong with wal_compression Michael Paquier <michael@paquier.xyz>
Re: Something is wrong with wal_compression Michael Paquier <michael@paquier.xyz>
Re: Something is wrong with wal_compression Tom Lane <tgl@sss.pgh.pa.us>
Hi, On 2023-01-27 16:15:08 +1300, Thomas Munro wrote: > It would be pg_current_xact_id() that would have to pay the cost of > the WAL flush, not pg_xact_status() itself, but yeah that's what the > patch does (with some optimisations). I guess one question is whether > there are any other reasonable real world uses of > pg_current_xact_id(), other than the original goal[1]. txid_current() is a lot older than pg_current_xact_id(), and they're backed by the same code afaict. 8.4 I think. Unfortunately txid_current() is used in plenty montiring setups IME. I don't think it's a good idea to make a function that was quite cheap for 15 years, suddenly be several orders of magnitude more expensive... Greetings, Andres Freund
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата: