Re: dropping an index inside a transaction

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Andy Chambers <achambers(at)mcna(dot)net>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: dropping an index inside a transaction
Date: 2012-03-18 03:20:00
Message-ID: CAOR=d=3eaJDN5zkXGm6dps+==NzfW2DVTTo8JufAWgKtyp7nuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Mar 17, 2012 at 8:37 PM, Andy Chambers <achambers(at)mcna(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-03-18 03:21:46 Re: dropping an index inside a transaction
Previous Message Andy Chambers 2012-03-18 02:37:24 dropping an index inside a transaction