Re: temporary indexes?
От | Andreas Kretschmer |
---|---|
Тема | Re: temporary indexes? |
Дата | |
Msg-id | 20151022063221.GA31413@tux обсуждение исходный текст |
Ответ на | temporary indexes? (Jonathan Vanasco <postgres@2xlp.com>) |
Список | pgsql-general |
Jonathan Vanasco <postgres@2xlp.com> 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°
В списке pgsql-general по дате отправления: