Jonathan Vanasco <postgres@xxxxxxxx> 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 TEMPORARY TABLE? Not sure if you mean something like this: http://www.depesz.com/2015/09/07/hypothetical-indexes/ > When creating temporary tables for analytics/reporting, I've noticed > that I often need to create (then drop) indexes on regular tables. Than you have to create this index. But the creation of an index is expensive, maybe it's cheaper do the nalytics/reporting without an index. And yes: you can create an indexe concurrently. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
