Re: dropping an index inside a transaction - Mailing list pgsql-general

From Scott Marlowe
Subject Re: dropping an index inside a transaction
Date
Msg-id CAOR=d=3eaJDN5zkXGm6dps+==NzfW2DVTTo8JufAWgKtyp7nuQ@mail.gmail.com
Whole thread Raw
In response to dropping an index inside a transaction  (Andy Chambers <achambers@mcna.net>)
List pgsql-general
On Sat, Mar 17, 2012 at 8:37 PM, Andy Chambers <achambers@mcna.net> wrote:
> Hi All,
>
> If one drops an index inside a transaction, is that index still usable
> by other transactions?  My use-case is loading millions of records
> into a heavily indexed table.  I'd like to speed up the load by
> temporarily dropping the indices.  I'm wondering if I can do this
> inside a transaction so that the rest of the application can still
> benefit from the indices.

pgsql-general by date:

Previous
From: Andy Chambers
Date:
Subject: dropping an index inside a transaction
Next
From: Scott Marlowe
Date:
Subject: Re: dropping an index inside a transaction