The issue with accessing tableau dashboards whenever we trigger a batch job that uses the pg_advisory_xact_lock function
I have a parent schema named "Customer", every day a batch job gets triggered and it creates a child schema named "SME" and load the data to all the tables under the schema, at the end of the batch job there is a cleanup process happens, which packs all the tables under "SME" as a partition to "Customer" schema for this process, they have used pg_advisory_xact_lock function. During this batch job whenever the user accesses the tableau dashboards they experience a data load issue, is there an alternative way to do this above process apart from applying the pg_advisory_xact_lock function