From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Speed up Clog Access by increasing CLOG buffers |
Date: | 2016-09-29 13:47:09 |
Message-ID: | CA+TgmobcD95v4QeD76qWcwTGE7P_31KVxBQGyS6yLh=dubvSfw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Sep 28, 2016 at 9:10 PM, Tomas Vondra
<tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
>> I feel like we must be missing something here. If Dilip is seeing
>> huge speedups and you're seeing nothing, something is different, and
>> we don't know what it is. Even if the test case is artificial, it
>> ought to be the same when one of you runs it as when the other runs
>> it. Right?
>>
> Yes, definitely - we're missing something important, I think. One difference
> is that Dilip is using longer runs, but I don't think that's a problem (as I
> demonstrated how stable the results are).
It's not impossible that the longer runs could matter - performance
isn't necessarily stable across time during a pgbench test, and the
longer the run the more CLOG pages it will fill.
> I wonder what CPU model is Dilip using - I know it's x86, but not which
> generation it is. I'm using E5-4620 v1 Xeon, perhaps Dilip is using a newer
> model and it makes a difference (although that seems unlikely).
The fact that he's using an 8-socket machine seems more likely to
matter than the CPU generation, which isn't much different. Maybe
Dilip should try this on a 2-socket machine and see if he sees the
same kinds of results.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2016-09-29 13:51:32 | Re: Set log_line_prefix and application name in test drivers |
Previous Message | Tom Lane | 2016-09-29 13:25:59 | Re: postgresql infinite loop |