Can't save using Gutenberg (large database, elastic)

[yarovikov]

• [x] I've read and understood the contribution guidelines.
• [x] I've searched for any related issues and avoided creating a duplicate issue.

Please give us a description of what happened

Hi there. I'v got large database (1+ million posts, 1+ million users). Also i use Elastic for fast queries, search, etc.

Currently i can't save post and yoast data using gutenberg editor.

Updating failed. The response is not a valid JSON response.

Failed to load resource: the server responded with a status of 504 () - https://site-name.com/wp-json/wp/v2/pages/3601475?_locale=user

This happens on pages that contain server-side gutenberg blocks with posts and user data. Each block uses rest api (own url).

If i deactivate Yoast plugin and save the post again, there are no errors. Also no any errors on clean or small database.

• If relevant, which editor is affected (or editors):

• [x] Block Editor
• [x] Gutenberg Editor
• [ ] Elementor Editor
• [ ] Classic Editor
• [ ] Other:

• Which browser is affected (or browsers):

• [x] Chrome
• [x] Firefox
• [x] Safari

Used versions

• Device you are using: Macbook
• Operating system: Sonoma
• PHP version: 8.2.22 (Supports 64bit values)
• WordPress version: 6.6.1
• WordPress Theme: Custom
• Yoast SEO version: 23.2.

Server: Linux 4.19.0-21-amd64 x86_64, nginx/1.22.0