out-of-order caution

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема out-of-order caution
Дата
Msg-id 4EA93576020000250004276C@gw.wicourts.gov
обсуждение исходный текст
Ответы Re: out-of-order caution
Список pgsql-hackers
On the docs page for the SELECT statement, there is a caution which
starts with:
| It is possible for a SELECT command using ORDER BY and FOR
| UPDATE/SHARE to return rows out of order. This is because ORDER BY
| is applied first.
Is this risk limited to queries running in READ COMMITTED
transactions?  If so, I think that should be mentioned in the
caution.
-Kevin


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Hot Backup with rsync fails at pg_clog if under load
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: out-of-order caution