Postgres Pro
Downloads
Home   >   mailing lists

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

From Andy Chambers
Subject dropping an index inside a transaction
Date
Msg-id CAAfW55rncZLeW=7_Utbm7njxWtynHzAv71hgJDr_jszLNmVMQA@mail.gmail.com
Whole thread Raw
Responses Re: dropping an index inside a transaction  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: dropping an index inside a transaction  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
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.

Cheers,
Andy

--
Andy Chambers
Software Engineer
(e) achambers@mcna.net

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: One more query
Next
From: Scott Marlowe
Date:
Subject: Re: dropping an index inside a transaction