pgsql: Repair performance regression in information_schema.triggers vie

2020-04-24 Thread Tom Lane
Repair performance regression in information_schema.triggers view. Commit 32ff26911 introduced use of rank() into the triggers view to calculate the spec-mandated action_order column. As written, this prevents query constraints on the table-name column from being pushed below the window aggregate

pgsql: Repair performance regression in information_schema.triggers vie

2020-04-24 Thread Tom Lane
Repair performance regression in information_schema.triggers view. Commit 32ff26911 introduced use of rank() into the triggers view to calculate the spec-mandated action_order column. As written, this prevents query constraints on the table-name column from being pushed below the window aggregate

pgsql: Repair performance regression in information_schema.triggers vie

2020-04-24 Thread Tom Lane
Repair performance regression in information_schema.triggers view. Commit 32ff26911 introduced use of rank() into the triggers view to calculate the spec-mandated action_order column. As written, this prevents query constraints on the table-name column from being pushed below the window aggregate