| From: | Alik Khilazhev <a(dot)khilazhev(at)postgrespro(dot)ru> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [WIP] Zipfian distribution in pgbench |
| Date: | 2017-07-14 13:37:50 |
| Message-ID: | 13667926-1389-410E-A77F-75B2511347B7@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On 13 Jul 2017, at 23:13, Peter Geoghegan <pg(at)bowt(dot)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 ktps respectively.
Tests was executed with configuration set for YCSB. And there is very aggressively autovacuum, this can be reason why there is 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
| Attachment | Content-Type | Size |
|---|---|---|
| pgbench_index_after_128_10min.txt | text/plain | 17.9 KB |
| pgbench_index_after_32_10min.txt | text/plain | 17.9 KB |
| unknown_filename | text/plain | 119 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marina Polyakova | 2017-07-14 13:41:49 | Re: WIP Patch: Pgbench Serialization and deadlock errors |
| Previous Message | Haribabu Kommi | 2017-07-14 13:35:56 | Re: Pluggable storage |