Re: CSStorm occurred again by postgreSQL8.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CSStorm occurred again by postgreSQL8.2
Дата
Msg-id 22293.1154982461@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CSStorm occurred again by postgreSQL8.2  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> I was thinking at what time was the most appropiate to insert or remove
> an Xid from the cache.  We can do without any excl-locking because 1) we
> already assume the storing of an Xid to be atomic, and 2) no one can be
> interested in querying for an Xid before the originating transaction has
> had the chance to write a tuple with that Xid anyway.

Actually ... that fails if GetSnapshotData is going to copy subtrans
XIDs.  So this area needs more thought.

> On the third hand, are we going to sh-acquire the ProcArray lock while a
> GetSnapshotData copies all subxact Xids of all running transactions?
> ProcArrayLock will become more of a contention point than it already is.

Yeah, but sharelock is better than exclusive lock ...
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: buildfarm - make check failures for leveret on 8.0
Следующее
От: Constantin Teodorescu
Дата:
Сообщение: PostgreSQL performance enhancement when query planner fails to guess the right plan