Hi,
Thank you for your interest in this thread.
> You could create database on RAM disk and make benchmarks.
According to your advice, I created RAM disk and put input files and data directory on RAM disk.
But the result changed only a few seconds.
In this test case, the table is unlogged table and shared_buffers is enough.
So, I think the disk performance does not affect so much.
> P.S. Could you point where is the performance measurement script you
> mantioned in you email?
> I will try to play with it.
Thank you.
Please use the "test.sh" in the following e-mail.
https://www.postgresql.org/message-id/flat/TY3PR01MB11891C0FD066F069B113A2376823E2%40TY3PR01MB11891.jpnprd01.prod.outlook.com#8455c9f7b66780a356511f5cfe029d57
Regards,
Ryohei Takahashi