I have been working on some server issues for the past month and a half. We have been exploring an existing install and deactivating everything until we ended up with plain install, no plugins, only the content - 2200 pages.
When navigating to "All pages" listing page throws memory error:
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 35 bytes) in ../wp-includes/wp-db.php on line 1396
I used wp-config.php, .htaccess and php.ini memory settings to set the memory size up to 512MB but no luck.
I have exported the content and tested it locally. Same problem - can't load the "All pages" screen. I separated the exported .xml file in 2 parts - 1750 pages and 390 pages. When I install one of them, the install works (so no invalid content or something).
I did some research in the edit.php page, passing to post.php, up to the wp() function but I was unable to find the exact query used. Is there any chance that the query WordPress functions in listing page through the get_list_table function try to load the full data instead of limiting the content and optimizing the calls? There are some paging parameters but yet again that's leading to my memory issue.