Re: Building multiple indexes on one table.

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Building multiple indexes on one table.
Дата
Msg-id CAGTBQpZUJwhmQJVswdpUG44szQdiSf2a0ECgJGej18_mOKXmWQ@mail.gmail.com
обсуждение исходный текст
Ответ на Building multiple indexes on one table.  (Chris Ruprecht <chris@cdrbill.com>)
Ответы Re: Building multiple indexes on one table.  (Marc Mamin <M.Mamin@intershop.de>)
Список pgsql-performance
On Thu, Jul 17, 2014 at 7:47 PM, Chris Ruprecht <chris@cdrbill.com> wrote:
> Is there any way that I can build multiple indexes on one table without having to scan the table multiple times? For
smalltables, that's probably not an issue, but if I have a 500 GB table that I need to create 6 indexes on, I don't
wantto read that table 6 times. 
> Nothing I could find in the manual other than reindex, but that's not helping, since it only rebuilds indexes that
arealready there and I don't know if that reads the table once or multiple times. If I could create indexes inactive
andthen run reindex, which then reads the table once, I would have a solution. But that doesn't seem to exist either. 

Just build them with separate but concurrent connections, and the
scans will be synchronized so it will be only one.

Btw, reindex rebuilds one index at a time, so what I do is issue
separate reindex for each index in parallel, to avoid the repeated
scans as well.

Just make sure you've got the I/O and CPU capacity for it (you'll be
writing many indexes at once, so there is a lot of I/O).


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

Предыдущее
От: Chris Ruprecht
Дата:
Сообщение: Building multiple indexes on one table.
Следующее
От: Benjamin Dugast
Дата:
Сообщение: Blocking every 20 sec while mass copying.