Request a Demo
Home   >   mailing lists

RE: parallel data loading for pgbench -i - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: parallel data loading for pgbench -i
Date
Msg-id TYRPR01MB121560B291DA3CD262CC7A09AF568A@TYRPR01MB12156.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: parallel data loading for pgbench -i  (lakshmi <lakshmigcdac@gmail.com>)
Responses Re: parallel data loading for pgbench -i
List pgsql-hackers
Tree view 
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?

Best regards,
Hayato Kuroda
FUJITSU LIMITED

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: [PATCH] Fix incorrect Spanish translation and remove obsolete FIXME comments
Next
From: Nazir Bilal Yavuz
Date:
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD