Ryohei Takahashi (Fujitsu) писал(а) 2024-12-19 16:13:
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
Hi!
I tested with text (CREATE UNLOGGED TABLE test (c TEXT STORAGE PLAIN)
WITH (autovacuum_enabled = off)).
Time is ~10% higher, but I also do not see strict dependence on version.
I think, antivirus can influence the performace, I did not switched it
off.
How can I help you in testing? Probably better to test and compare
result only with one quantity of clients.
For 1 client the read time of the input file has the big effect, for
many clients their concurrency overhead has
big effect. Maybe make the series of the runs with 2 or 4 clients only
and compare?
--
Best regards,
Vladlen Popolitov.
