RE: COPY performance on Windows

Hi

Thank you for your advice and testing.

> I think, it could be checked, if table has text fields instead of
> numeric - we could exclude numeric conversion
> and have the same input-output operations (really more IO-operation, but
> we need to compare)

I changed the column from int to text.
The performance becomes worse in each version,
but the rate of the difference of duration did not change.

> By the way, do you use prebuild Postgres versions for this test or
> build it by yourself with the same options? I am going to use built
> myself.

In the mail in 2024-12-16 12:09:03, I used the modules which I build by myself.
In the other mail, I used the modules which community provides at following.
https://www.postgresql.org/download/windows/

> Could you confirm, that you receive you results on all execution orders
> (17.0 first and 17.0 last)?

In my environment, the results do not depend on order.
(The performance of the order 16.4, 16.6, 17.0 is same as that of the order 17.0, 16.6, 16.4)

Regards,
Ryohei Takahashi