Re: CREATE INDEX and HOT - revised design
От | Pavan Deolasee |
---|---|
Тема | Re: CREATE INDEX and HOT - revised design |
Дата | |
Msg-id | 2e78013d0703211045r3120cd62u19bcc02552326a1b@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: CREATE INDEX and HOT - revised design ("Merlin Moncure" <mmoncure@gmail.com>) |
Ответы |
Re: CREATE INDEX and HOT - revised design
|
Список | pgsql-hackers |
On 3/21/07, Merlin Moncure <mmoncure@gmail.com> wrote:
On 3/21/07, Pavan Deolasee <pavan.deolasee@gmail.com> wrote:
> It seems much simpler to me do something like this. But important
> question is whether the restriction that CREATE INDEX can not
> be run in a transaction block is acceptable ?
yikes -- this is huge, huge price to pay, IMHO. Think about DDL that
implies index creation such as adding unique constraint to a table,
many postgresql users (including me) take advantage of that in update
systems to production databases.
I didn't understand that quite well. How does it help to run CREATE
INDEX inside a transaction ?
Thanks,
Pavan
--
EnterpriseDB http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: