Heikki Hellgren
Heikki Hellgren
Not stale, needs discussion
> @drodil I have already worked on PR #22344 Hah, great 👍 Didn't see that, just wanted to fill in the cap with the signals service so made this 😆
> Yes, I had the signals plugin also on my radar. We need to add event support to other event users like some catalog modules as well. I've planned to...
@freben Yeah makes sense to run some performance tests for this. Taking a look at the queries done against the `search` table: - delete done by entity_id in `performStitching` -...
@alde I understand. Maybe a view could be an option or changing the search to a completely new table that is re-populated?
Btw, there is an old discussion about Knex supporting creating indexes concurrently here https://github.com/knex/knex/issues/3913 but most likely it will not see daylight as it's almost 4 years old.
So applied the index to another instance. Here are the results: # Catalog search key+value index Query plan query used: ```sql SELECT * FROM final_entities LEFT JOIN search ON final_entities.entity_id...
Refactored this to use `CONCURRENTLY` for creating and dropping indexes. Still need to decide if we can drop the old indexes or not.
@Rugvip please go ahead and test it at your instance. At our instance it already makes the catalog somewhat usable again even without pagination 😆