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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
