temporary indexes?

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: temporary indexes?
Date: 2015-10-21 18:43:56
Message-ID: E78D807E-D89E-4441-AF8A-1304A84529F2@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 TEMPORARY TABLE?

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-10-21 18:46:24 Re: ERROR: invalid page in block 1226710 of relation base/16750/27244
Previous Message bricklen 2015-10-21 18:16:41 ERROR: invalid page in block 1226710 of relation base/16750/27244