RE: COPY performance on Windows

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