4 ms·
Of course they don't affect other queries, these would be non-locking queries on replicas. Or, to be even more accurate, they'd be non blocking queries on indic
by pcnix 7y ago
Of course they don't affect other queries, these would be non-locking queries on replicas. Or, to be even more accurate, they'd be non blocking queries on indices cached in memory on edge servers and probably several levels of optimization beyond that. There's no reason for these type of queries to lock a database.
- amelius 7y agoI wasn't concerned about locking, but more about resource utilization. Searches are read-only, so I suppose locking doesn't need to happen anyway.