Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows

Поиск
Список
Период
Сортировка
Искать
От
Emil Iggland
Тема
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows
Дата
Msg-id
67eecc51-ef05-2990-b039-d4ddc8c63c8a@iggland.com
Ответ на
Список
Дерево обсуждения
BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows PG Bug reporting form <noreply@postgresql.org>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows David Christensen <david.christensen@crunchydata.com>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows Emil Iggland <emil@iggland.com>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows Emil Iggland <emil@iggland.com>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows David Christensen <david.christensen@crunchydata.com>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows Emil Iggland <emil@iggland.com>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows Emil Iggland <emil@iggland.com>
Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows Emil Iggland <emil@iggland.com>
FWIW, the following query exhibits the behaviour that I expect, but
isn't really usable in production as I do not know how many rows to
expect per worker.

BEGIN;
SELECT * FROM queue
ORDER BY task DESC
LIMIT 2 OFFSET 0
FOR UPDATE SKIP LOCKED;
COMMIT;




В списке pgsql-bugs по дате отправления
От: PG Bug reporting form
Дата:
От: Emil Iggland
Дата:
FAQ