From: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PATCH: pgbench / int64 instead of int for xact count |
Date: | 2014-05-25 16:05:03 |
Message-ID: | 538214AF.2070200@fuzzy.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I've been running a few longer pgbench tests (~week), and I've run into
this:
transaction type: SELECT only
scaling factor: 1250
query mode: simple
number of clients: 32
number of threads: 4
duration: 605000 s
number of transactions actually processed: -1785047856
latency average: -10.846 ms
tps = -2950.492090 (including connections establishing)
tps = -2950.492325 (excluding connections establishing)
The instance was doing ~10k tps for a week, which caused overflow of the
int counter, used to track number of transactions. Hence the negative
values.
I think we've reached the time when hardeare capable of doing this is
pretty common (SSDs, ...), so I think it's time to switch the counter to
int64.
Tomas
Attachment | Content-Type | Size |
---|---|---|
pgbench-int64.patch | text/x-diff | 1.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-05-25 17:01:09 | Re: pg_recvlogical not accepting -I to specify start LSN position |
Previous Message | Andres Freund | 2014-05-25 16:01:34 | Re: assertion in 9.4 with wal_level=logical |