> On 13 Jul 2017, at 23:13, Peter Geoghegan <pg@bowt.ie> wrote:
>
> I just figured out that "result.txt" is only a 60 second pgbench run.
> Is the same true for other tests?
Yes, other tests ran 60 seconds too.
>
> It would be much more interesting to see runs that lasted 10 minutes
> or more.
I am attaching results of tests for 32 and 128 clients that were running for 10 minutes, and TPS remains 305 and 115
ktpsrespectively.
Tests was executed with configuration set for YCSB. And there is very aggressively autovacuum, this can be reason why
thereis no decline appears with increasing working time.
Autovacuum config:
autovacuum_max_workers = 8
autovacuum_naptime = 10s
autovacuum_vacuum_scale_factor = 0.1
autovacuum_vacuum_cost_delay = 0ms
autovacuum_vacuum_cost_limit = 10000
—
Thanks and Regards,
Alik Khilazhev
Postgres Professional:
http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers