Re: CREATE INDEX and HOT (was Question: pg_classattributes and race conditions ?)

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: CREATE INDEX and HOT (was Question: pg_classattributes and race conditions ?)
Дата
Msg-id 1174157818.4160.652.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: CREATE INDEX and HOT (was Question: pg_class attributes and race conditions ?)  ("Pavan Deolasee" <pavan.deolasee@enterprisedb.com>)
Ответы Re: CREATE INDEX and HOT (was Question: pg_classattributes and race conditions ?)  ("Pavan Deolasee" <pavan.deolasee@enterprisedb.com>)
Список pgsql-hackers
Дерево обсуждения 
On Sat, 2007-03-17 at 23:11 +0530, Pavan Deolasee wrote:

> The algorithm would look like:
> 
> 1. Disable HOT-updates

The lock held by CREATE INDEX already prevents HOT updates. So steps 1
and 8 aren't needed.

We need to be clear that we already have a solution to CREATE INDEX
CONCURRENTLY. Do you agree that we do? Does anyone see a problem with
the posted design for that?

Hopefully it is only CREATE INDEX that we need to think about.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: "Mickael DELOISON"
Дата:
Сообщение: Project suggestion: benchmark utility for PostgreSQL
Следующее
От: "Pavan Deolasee"
Дата:
Сообщение: Re: CREATE INDEX and HOT (was Question: pg_classattributes and race conditions ?)