Re: temporary indexes? - Mailing list pgsql-general

From vincent elschot
Subject Re: temporary indexes?
Date
Msg-id 5628D3F0.7040709@xs4all.nl
Whole thread Raw
In response to temporary indexes?  (Jonathan Vanasco <postgres@2xlp.com>)
List pgsql-general

On 21-10-15 20:43, Jonathan Vanasco wrote:
> 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
onregular tables.  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!) 
>
Do you mean creating a temporary index on a non-temporary table to speed
up the queries that fills the temporary table?


pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: temporary indexes?
Next
From: Adrian Klaver
Date:
Subject: Re: Migrate whole cluster to utf8