Hello,
I have a question that involves two Aurora Postgres RDS clusters.
I have two clusters. With long-running transactions, one of them is able to
create a replication slot when a record is inserted into a table while the
other does not and is blocked. It does create the replication slot when t
A few more examples:
1. Why are different query_ids displayed in the log for this test query?
2025-07-01 13:38:47.852 MSK [2518006:549/405366] [postgres] pgAdmin
*-11391618518959119* 10.206.112.24(51180) LOG: duration: 101.141 ms plan:
Query Text: BEGIN;
select pg_sleep(.1);
Hi. I noticed that in pg_stat_activity different queries have the same
query_id.
SELECT query_id, query FROM pg_stat_activity WHERE query_id =
2064869707185898531
2064869707185898531;'BEGIN;...' -- the full text in query1.sql attachment
2064869707185898531;'COMMIT;'
there is another example, if
On Tue, Jul 01, 2025 at 10:24:14AM +0300, Maksim Gorkov wrote:
> 2064869707185898531;'BEGIN;...' -- the full text in query1.sql attachment
> 2064869707185898531;'COMMIT;'
>
> there is another example, if required I can send it for review.
>
> Why does this happen and how can it be fixed?
Hard to
