pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSubtransactions in PostgreSQL
3+ messages / 2 participants
[nested] [flat]
* Subtransactions in PostgreSQL
@ 2023-01-03 18:10 Amine Tengilimoglu <aminetengilimoglu@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Amine Tengilimoglu @ 2023-01-03 18:10 UTC (permalink / raw)
To: pgsql-admin
Hello everyone;
Is there any way to detect the main transaction of a subtransaction
in postgres, or any tool that can read the files in pg_subtrans?
PG version: 14.5
thank you.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Subtransactions in PostgreSQL
@ 2023-01-03 19:06 Jeremy Schneider <schneider@ardentperf.com>
parent: Amine Tengilimoglu <aminetengilimoglu@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jeremy Schneider @ 2023-01-03 19:06 UTC (permalink / raw)
To: Amine Tengilimoglu <aminetengilimoglu@gmail.com>; pgsql-admin
On 1/3/23 10:10 AM, Amine Tengilimoglu wrote:
> Is there any way to detect the main transaction of a subtransaction in
> postgres, or any tool that can read the files in pg_subtrans?
Would this extension help?
https://github.com/bdrouvot/pg_subtrans_infos
--
http://about.me/jeremy_schneider
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Subtransactions in PostgreSQL
@ 2023-01-03 19:13 Amine Tengilimoglu <aminetengilimoglu@gmail.com>
parent: Jeremy Schneider <schneider@ardentperf.com>
0 siblings, 0 replies; 3+ messages in thread
From: Amine Tengilimoglu @ 2023-01-03 19:13 UTC (permalink / raw)
To: Jeremy Schneider <schneider@ardentperf.com>; +Cc: pgsql-admin
Thanks a lot, I think this will work for me.
Jeremy Schneider <schneider@ardentperf.com>, 3 Oca 2023 Sal, 22:06
tarihinde şunu yazdı:
> On 1/3/23 10:10 AM, Amine Tengilimoglu wrote:
>
> Is there any way to detect the main transaction of a subtransaction in
> postgres, or any tool that can read the files in pg_subtrans?
>
>
> Would this extension help?
>
> https://github.com/bdrouvot/pg_subtrans_infos
>
>
> -- http://about.me/jeremy_schneider
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-01-03 19:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-03 18:10 Subtransactions in PostgreSQL Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2023-01-03 19:06 ` Jeremy Schneider <schneider@ardentperf.com>
2023-01-03 19:13 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox