Re: pg_stat_statements vs. SELECT FOR UPDATE

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: pg_stat_statements vs. SELECT FOR UPDATE
Дата
Msg-id 155239676712.16480.16065508191585312491.pgcf@coridan.postgresql.org
обсуждение исходный текст
Ответ на Re: pg_stat_statements vs. SELECT FOR UPDATE  (Vik Fearing <vik.fearing@2ndquadrant.com>)
Ответы Re: pg_stat_statements vs. SELECT FOR UPDATE
Список pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  tested, passed
Implements feature:       tested, passed
Spec compliant:           not tested
Documentation:            not tested

Hello

Patch is applied cleanly, compiles and pass check-world. Has tests and does not need documentation changes since old
behaviorwas not documented
 
Well, I can not say something about code.

> SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id FOR UPDATE OF pgss_a, pgss_b; -- should not appear

This query is counted as second "SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id FOR UPDATE". I prefer a
bitmore verbose comment here. Firstly I was surprised by both questions "why should not appear?" and "where was the
secondquery call?"
 

regards, Sergei

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Offline enabling/disabling of data checksums
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: POC: Cleaning up orphaned files using undo logs