Onur Oğurtanı
Onur Oğurtanı
Hello @yang-xiaodong We are using the following two nonclustered indexes: ``` CREATE NONCLUSTERED INDEX [IDX_Candidate_Published_Version_ExpiresAt_StatusName] ON [Candidate].[Published] ([Version] ASC, [ExpiresAt] ASC, [StatusName] ASC) INCLUDE ([Id], [Content], [Retries], [Added]); CREATE NONCLUSTERED...
Yang, I'm interested in this topic. Are there any updates?
Yang, would you like to try this? We can solve the problem you mentioned using a subquery:↳ Another alternative could be to completely separate these two queries. ``` SELECT "Id",...
I think that by running the two queries independently or separating them into different methods, we can effectively overcome the limitations with FOR UPDATE SKIP LOCKED in PostgreSQL when using...
I'm excited to try it out; thank you!
Hi Yang, I think the development is complete. How can I test it? Are you planning to release a preview package?