Many logical replication synchronization worker threads kicking off for ONE table

2023-03-16 Thread Dolan, Sean
a quick fashion and therefore kicks off more synchronization threads? Anything I can do to prevent this? Thank you -Original Message- From: Laurenz Albe Sent: Thursday, March 16, 2023 1:25 PM To: Dolan, Sean (US N-ISYS Technologies Inc.) ; pgsql-general@lists.postgresql.org Subje

RE: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows!

2023-03-16 Thread Dolan, Sean
form the action. Is there a way to see if there is a transaction on that table like you allude to? -Original Message- From: Laurenz Albe Sent: Wednesday, March 15, 2023 11:45 PM To: Dolan, Sean (US N-ISYS Technologies Inc.) ; pgsql-general@lists.postgresql.org Subject: EXTERNAL: Re: &

"No Free extents", table using all allocated space but no rows!

2023-03-15 Thread Dolan, Sean
Environment: PostGres 13 on RedHat 7.9. I am using logical replication (publisher/subscriber) between two databases and there are times where one of our schemas gets to 100% of allocated space (No Free Extents). I went into the schema and did a \dt+ to see the amount of size being used and I