Re: temporary indexes?

Поиск
Список
Период
Сортировка
От vincent elschot
Тема Re: temporary indexes?
Дата
Msg-id 5628D3F0.7040709@xs4all.nl
обсуждение исходный текст
Ответ на temporary indexes?  (Jonathan Vanasco <postgres@2xlp.com>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: temporary indexes?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Migrate whole cluster to utf8