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 1174165912.4160.660.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: CREATE INDEX and HOT (was Question: pg_classattributes and race conditions ?)  ("Pavan Deolasee" <pavan.deolasee@enterprisedb.com>)
Список pgsql-hackers
On Sun, 2007-03-18 at 00:44 +0530, Pavan Deolasee wrote:
> Simon Riggs wrote:
>  >
>  > 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?

If we have solved CREATE INDEX CONCURRENTLY, then I would propose that
this becomes the default option for creating an index, when the
statement is issued outside of a statement block.

That seems better than reminding everybody to run with the CONCURRENTLY
option, or advise them of different performance characteristics or
behaviour of the normal CREATE INDEX route.

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




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

Предыдущее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: Project suggestion: benchmark utility for PostgreSQL
Следующее
От: Grzegorz Jaskiewicz
Дата:
Сообщение: Re: [PATCHES] Bitmapscan changes