Re: temporary indexes? - Mailing list pgsql-general

From Jonathan Vanasco
Subject Re: temporary indexes?
Date
Msg-id 06082E1B-BEA7-49F6-A3B9-9C0F14797725@2xlp.com
Whole thread Raw
In response to Re: temporary indexes?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: temporary indexes?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: temporary indexes?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
On Oct 21, 2015, at 3:42 PM, Adrian Klaver wrote:

> I misunderstood then. The only thing I can think of is to wrap in a transaction, though that presents other issues
withopen transactions and/or errors in the transaction. 

I just explicitly drop.  The convenience of an auto-drop would be a nice backup.

Transactions and table-locking issues are probably why temporary indexes don't exist.

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: ERROR: invalid page in block 1226710 of relation base/16750/27244
Next
From: John R Pierce
Date:
Subject: Re: trouble downloading postgres 9.4 for RHEL 6.x