Re: Building multiple indexes concurrently
От
Tom Lane
Тема
Re: Building multiple indexes concurrently
Дата
Msg-id
27969.1268836243@sss.pgh.pa.us
Ответ на
Re: Building multiple indexes concurrently (Greg Smith)
Список
Дерево обсуждения
Building multiple indexes concurrently Rob Wultsch <wultsch@gmail.com>
Re: Building multiple indexes concurrently Greg Smith <greg@2ndquadrant.com>
Re: Building multiple indexes concurrently Tom Lane <tgl@sss.pgh.pa.us>
Re: Building multiple indexes concurrently Rob Wultsch <wultsch@gmail.com>
Re: Building multiple indexes concurrently Greg Smith <greg@2ndquadrant.com>
Re: Building multiple indexes concurrently Andres Freund <andres@anarazel.de>
Re: Building multiple indexes concurrently Alvaro Herrera <alvherre@commandprompt.com>
Re: Building multiple indexes concurrently Greg Smith <greg@2ndquadrant.com>
Re: Building multiple indexes concurrently Hannu Krosing <hannu@2ndquadrant.com>
Re: Building multiple indexes concurrently Justin Pitts <justinpitts@gmail.com>
Re: Building multiple indexes concurrently Hannu Krosing <hannu@2ndquadrant.com>
Re: Building multiple indexes concurrently Justin Pitts <justinpitts@gmail.com>
Re: Building multiple indexes concurrently Andres Freund <andres@anarazel.de>
Re: Building multiple indexes concurrently Ben Chobot <bench@silentmedia.com>
Greg Smith writes: > Rob Wultsch wrote: >> At a minimum I assume that if both of the commands were started at >> about the same time they would each scan the table in the same >> direction and whichever creation was slower would benefit from most of >> the table data it needed being prepopulated in shared buffers. Is this >> the case? > This might be optimistic; No, it's not optimistic in the least, at least not since we implemented synchronized seqscans (in 8.3 or thereabouts). regards, tom lane
В списке pgsql-performance по дате отправления
