Re: Tricky bugs in concurrent index build

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Tricky bugs in concurrent index build
Дата
Msg-id 44EB6283.70101@commandprompt.com
обсуждение исходный текст
Ответ на Re: Tricky bugs in concurrent index build  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Tricky bugs in concurrent index build
Список pgsql-hackers
> 
>> Wow, that seems pretty unsatisfactory, all the waiting and locking sounds
>> awful.
> 
> Yeah, I'm very unhappy.  The whole idea may be going down in flames :-(
> It's fairly clear that we could support concurrent builds of nonunique
> indexes, but is that enough of a use-case to justify it?

I believe there would be. Most PostgreSQL users I run into, develop in 
production, which means being able to add an index they forgot when 
doing query analysis.

Most of the time (I would say >95%) this is not a unique index.

Sincerely,

Joshua D. Drake


> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 


-- 
   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240   Providing the most comprehensive  PostgreSQL
solutionssince 1997             http://www.commandprompt.com/
 




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Tricky bugs in concurrent index build
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] COPY view