Postgres Pro
Downloads
Home   >   mailing lists

Re: Online index builds - Mailing list pgsql-general

From Tom Lane
Subject Re: Online index builds
Date
Msg-id 8976.1166029266@sss.pgh.pa.us
Whole thread Raw
In response to Re: Online index builds  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Tree view 
Csaba Nagy <nagy@ecircle-ag.com> writes:
> With the "mess" you refer to the new index, and the fact it is
> impossible to delete it if not possible to replace the old one ? I fail
> to see why... you WILL get an exclusive lock, so you should be able to
> delete the index.

Consider the ALTER OWNER example ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Brendan O'Shea"
Date:
Subject: Re: Statement timeout not working on broken connections with active queries
Next
From: dananrg@yahoo.com
Date:
Subject: Re: TOAD-like query builder for PostgreSQL?