| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Alik Khilazhev <a(dot)khilazhev(at)postgrespro(dot)ru> |
| 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-13 17:02:09 |
| Message-ID: | CAH2-Wz=6e7udS0y0WpdNw4nUFXjkz7LCKAN0DCvRwsn7E66_7g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jul 13, 2017 at 4:38 AM, Alik Khilazhev
<a(dot)khilazhev(at)postgrespro(dot)ru> wrote:
> I am attaching results of test for 32 and 128 clients for original and
> patched(_bt_doinsert) variants.
Thanks.
The number of leaf pages at the left hand side of the leaf level seems
to be ~50 less than the unpatched 128 client case was the first time
around, which seems like a significant difference. I wonder why. Maybe
autovacuum ran at the right/wrong time this time around?
Did you happen to record TPS for this most recent set of tests?
I notice one possibly interesting thing from these new numbers: the 32
client case is slightly more bloated when unique index enforcement is
removed.
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-07-13 17:04:02 | Re: PostgreSQL - Weak DH group |
| Previous Message | Tom Lane | 2017-07-13 17:00:18 | Re: pl/perl extension fails on Windows |