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 по дате отправления: