temporary indexes? - Mailing list pgsql-general

From Jonathan Vanasco
Subject temporary indexes?
Date
Msg-id E78D807E-D89E-4441-AF8A-1304A84529F2@2xlp.com
Whole thread Raw
Responses Re: temporary indexes?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: temporary indexes?  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: temporary indexes?  (vincent elschot <vinny@xs4all.nl>)
List pgsql-general
I couldn't find any mention of this on the archives...

Have the project maintainers ever considered extending CREATE INDEX to support "temporary" indexes like CREATE
TEMPORARYTABLE? 

When creating temporary tables for analytics/reporting, I've noticed that I often need to create (then drop) indexes on
regulartables.  Temporary indexes seemed like a natural fit here, so i was wondering if there was any reason why
they'renot supported (other than no one wanted it!) 

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: ERROR: invalid page in block 1226710 of relation base/16750/27244
Next
From: Tom Lane
Date:
Subject: Re: ERROR: invalid page in block 1226710 of relation base/16750/27244