multiple sessions to create index in parallel support

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

   We have a large database that just migrated data from Oracle to Postgres(13.4), after data load. We try to create indexes ,  with only one connection , the create index automatically run in parallel (table size 40G) ,  then we started two connections and each session creating index on large table, but at this time, only 1 session parallel creating index, the other one creating index in serial. There are enough parallel_workers and memory.  Is that expected ?  only 1 session allowed to parallel index creating at the same time ?

 

Thanks,

 

James


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux