Re: Repeated PredicateLockRelation calls during seqscan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Repeated PredicateLockRelation calls during seqscan
Дата
Msg-id 29470.1308752899@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Repeated PredicateLockRelation calls during seqscan  (Dan Ports <drkp@csail.mit.edu>)
Ответы Re: Repeated PredicateLockRelation calls during seqscan  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Repeated PredicateLockRelation calls during seqscan  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Дерево обсуждения 
Dan Ports <drkp@csail.mit.edu> writes:
> I was looking at ExecSeqScan today and noticed that it invokes
> PredicateLockRelation each time it's called, i.e. for each tuple
> returned. Any reason we shouldn't skip that call if
> rs_relpredicatelocked is already set, as in the attached patch?

Why is the call in ExecSeqScan at all, and not in the node startup
function?
        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [v9.2] DROP Reworks Part.0 - 'missing_ok' support of get_object_address
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_dump vs malloc