On 04/21/2016 03:23 AM, Venkatesan, Sekhar wrote:
> For DROP_INDEX case, adding the lock_timeout setting to few seconds
> helps in clearing the DB locks and the drop index operation to complete.
>
> For ALTER table hang issue, none of the DB timeout settings are helping.
>
> Need your assistance to identify if there is any known issue when data
> partitioning is enabled in PostgreSQL DB.
You have shown the error, but it would be helpful to know what the setup is:
What are the tables involved in the partitioning scheme?
How is the partitioning been done?
How are the statements being sent to server?
In particular I am seeing a BEGIN on the DDL statements, is that coming
from you or the client software?
>
> Thanks,
> Sekhar
--
Adrian Klaver
adrian.klaver@aklaver.com