Re: temporary indexes?

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: temporary indexes?
Date: 2015-10-21 20:28:53
Message-ID: 06082E1B-BEA7-49F6-A3B9-9C0F14797725@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 with open 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2015-10-21 22:10:55 Re: trouble downloading postgres 9.4 for RHEL 6.x
Previous Message bricklen 2015-10-21 19:55:08 Re: ERROR: invalid page in block 1226710 of relation base/16750/27244