On Fri, Feb 20, 2026 at 3:29 PM Hayato Kuroda (Fujitsu) < [email protected]> wrote:
> Dear Iakshmi, > > Thanks for the measurement! > > > For scale 500, the serial initialization on my system takes around 34.3 > seconds. > > Using parallel initialization without partitions (-j 10) makes the > client-side > > data generation noticeably faster,But the overall runtime ends up > slightly > > higher because the vacuum phase becomes much longer. > > To confirm, do you know the reason why the VACUUMing needs more time than > serial case? > > Dear Hayato, Thank you for the question. >From what I observed,in the non-partitioned parallel case the data generation phase becomes much faster,but the VACUUM phase takes longer compared to the serial run. My current understanding is that this may be related to multiple workers inserting into the same heap relation.That could potentially affect page locality or increases the amount of freezing work required afterward.In contrast,the partitioned case seems to benefit more clearly,likely because each worker operates on a separate partition and COPY FREEZE reduces the vacuum effort. I have not yet done deeper internal analysis,so this is based on the behavior I measured rather than detailed inspection.If needed,I can try to collect additional statistics to better understand and difference. please let me know if this reasoning aligns with your understanding. Best regards Lakshmi > > >
