Re: Undetected Deadlock

Hi The undetected deadlock occurred again today and I was able to collect some more info. The presentation was very similar to the case I reported previously: - One backend trying to do a DROP TABLE on a partition of a partitioned table, waiting for an AccessExclusiveLock on that table - Another

Re: what is the solution like oracle DB's datafile

hello, thanks for the logical answer. it is true that there is a very big difference between open source and commercial DB. but I'm grateful to be able to use postgresql which is quite reliable. thank you Yours faithfully yudianto

Re: pg_try_advisory_lock is waiting?

On Fri, Jan 28, 2022 at 6:34 PM Mladen Gogala wrote: > > On 1/28/22 19:08, Tom Lane wrote: > > I doubt it. I think the FOR UPDATE in the sub-select is blocked > because the other session has an uncommitted update on the row > it wants to lock. This command won't reach the pg_try_advisory_lock >

Re: what is the solution like oracle DB's datafile

hello, thanks for all the solutions. I don't think there is a solution like Oracle DB's datafile in postgresql. LVM is probably the best way if using Linux OS. Thank You Yours faithfully yudianto

Can one call pg_total_relation_size over foreign data wrapper?

Hi Team, Can one call pg_total_relation_size over foreign data wrapper? Problem statement - I need to connect to 100s of databases over foreign data wrapper to collect the size of each table. As a part of that I have to use pg_total_relation_size over foreign data wrappers. Alternatively, I woul