Re: Proposal: Creating multiple indexes on a table using a single full table scan

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: Proposal: Creating multiple indexes on a table using a single full table scan
Дата
Msg-id CAJ7c6TPgzJ+jEAQQAkpYXtOu5bjqmW+v=vbBoJLWmjW3Z=Wweg@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hi Ildar,

> I’m curious:
> - Has this been discussed before?
> - Are there any technical reasons why this wouldn’t be feasible?
> - Would such a patch be of interest to the community?

This might be a promising area for research. I suggest starting with
figuring out where exactly the bottleneck is when you execute 10
queries CREATE INDEX on your particular database. There is a decent
chance that the actual bottleneck is far from the place you think it
might be (writing to the disk, as an example).

--
Best regards,
Aleksander Alekseev



В списке pgsql-hackers по дате отправления: