build multiple indexes in single table pass?
От | Andrew Dunstan |
---|---|
Тема | build multiple indexes in single table pass? |
Дата | |
Msg-id | 47F228DA.7090907@dunslane.net обсуждение исходный текст |
Ответы |
Re: build multiple indexes in single table pass?
Re: build multiple indexes in single table pass? Re: build multiple indexes in single table pass? Re: build multiple indexes in single table pass? Re: build multiple indexes in single table pass? |
Список | pgsql-hackers |
From the "idle thoughts in the middle of the night" department: I don't know if this has come up before exactly, but is it possible that we could get a performance gain from building multiple indexes from a single sequential pass over the base table? If so, that would probably give us a potential performance improvement in pg_restore quite apart from the projected improvement to be got from running several steps in parallel processes. The grammar might look a bit ugly, but I'm sure we could finesse that. cheers andrew
В списке pgsql-hackers по дате отправления: