Draft: [PP-1] Performance issues with path alias generated queries on PostgreSQL

Closes #2988018

Note this merge request contains commits from [#3397622]: we will need to rebase onto 11.x when [#3397622] is accepted.

added 1 commit

• 1221d3a3 - Tests missing declare(strict_types=1).

Compare with previous version

changed title from Draft: Resolve #2988018 "Postgresql path alias queries" to Draft: [PP-1] Performance issues with path alias generated queries on PostgreSQL

added 1 commit

• fc82acca - PathAliasIndexUpdateTest needs updated path to test fixture.

Compare with previous version