Re: query locks up when run concurrently

On 11/23/2016 01:47 PM, azhwkd wrote:
> Greetings!
>
> Yes I had a look at the logfiles but there is not a single logfile
> generated when I'm reproducing this issue.

We are talking about the Postgres logfile, correct?

I have to believe a log file exists, but maybe not entries at that time.

What are you logging settings?

> Concerning locks I used there queries
> at https://wiki.postgresql.org/wiki/Lock_Monitoring and they came up empty.
> The group_history table and its sub-tables do not have any foreign keys
> as they only contain calculated data and the source data is removed
> after some time.
> The trigger which calls the partition function below is defined as follows:
>
> create
>     trigger group_history_trigger before insert
>         on
>         item_history for each row execute procedure
> group_history_partition_function()

This trigger is on the table item_history not group history, is that
correct?

If so how does the item_history table fit into this?

>
> Kind regards,
> Sebastian


--
Adrian Klaver
adrian.klaver@aklaver.com