Repeated PredicateLockRelation calls during seqscan

Поиск
Список
Период
Сортировка
От Dan Ports
Тема Repeated PredicateLockRelation calls during seqscan
Дата
Msg-id 20110622045850.GN83336@csail.mit.edu
обсуждение исходный текст
Ответы Re: Repeated PredicateLockRelation calls during seqscan  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: Repeated PredicateLockRelation calls during seqscan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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?

That would save us a bit of overhead, since checking that flag is
cheaper than doing a hash lookup in the local predicate lock table
before bailing out.

Dan

--
Dan R. K. Ports              MIT CSAIL                http://drkp.net/

Вложения

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

Предыдущее
От: Brendan Jurd
Дата:
Сообщение: Re: Fwd: Keywords in pg_hba.conf should be field-specific
Следующее
От: Dan Ports
Дата:
Сообщение: Re: pika buildfarm member failure on isolationCheck tests