MicrosoftThank you for the detailed explanation, samay_sharma . I am a newbie to PostgreSQL, I am facing problems and still struggling to detect the root cause. Initially when I started the database size was very huge and causing many problems. I took downtime and ran vacuum full on those 3 tables after going through many articles; this reduced the size of the database drastically. And then I noticed that autovacuum started running properly. However, now on that server I noticed, it gives error as
1. Canceling autovacuum task. Could you please throw some light on this. Adding in the other issues just in case they are related.
2. Process "pid" waits for ShareLock on transaction xxxx; blocked by process yyy. (synchronous_commit = on)
3. Connection to client lost.
Not sure, how to proceed. Your advice would be very appreciated.
