On Sun, Sep 6, 2015 at 1:51 AM, Marc Mamin <m.ma...@intershop.de> wrote: > Have you considered performances for cases where multiple CREATE INDEX are > running in parallel? > One of our typical use case are large daily tables (50-300 Mio rows) with up > to 6 index creations > that start simultaneously. > Our servers have 40-60 GB RAM , ca. 12 CPUs and we set maintenance mem to 1-2 > GB for this. > If the create index themselves start using parallelism, I guess that we might > need to review our workflow...
Not particularly. I imagine that that case would be helped a lot here (probably more than a simpler case involving only one CREATE INDEX), because each core would be require fewer main memory accesses overall. Maybe you can test it and let us know how it goes. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
