SELECT FOR SHARE
От
Ilja Golshtein
Тема
SELECT FOR SHARE
Дата
Msg-id
43462540.000001.02943@ariel.yandex.ru
Список
Дерево обсуждения
SELECT FOR SHARE "Ilja Golshtein" <ilejn@yandex.ru>
Re: SELECT FOR SHARE Tom Lane <tgl@sss.pgh.pa.us>
Re: SELECT FOR SHARE "Ilja Golshtein" <ilejn@yandex.ru>
Hello! I'm interested in SELECT ... FOR SHARE 8.1 feature. I'd tried to measure performance degradation and got something about 30-60% for queries retrieve a lot of rows. Is it realistic estimation? Does this penalty depend on something (data types, triggers, foreign keys, whatever) significantly? Is any sort of lock escalation [and other unpreditable things] involved here? Last question. What about ISOLATION LEVEL REPEATABLE READ syntax since non-exclusive locking for all SELECTs means [as far as I understand] nothing but REPEATABLE READ? Thanks. -- Best regards Ilja Golshtein
В списке pgsql-general по дате отправления
