| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
| Cc: | David Steele <david(at)pgmasters(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Speed up Clog Access by increasing CLOG buffers |
| Date: | 2016-03-17 03:39:36 |
| Message-ID: | CAA4eK1KALqw1cDELpgd1rf6vZoVoWY9td+un54hgLpyH8LfK5Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Mar 16, 2016 at 11:57 PM, Jesper Pedersen <
jesper(dot)pedersen(at)redhat(dot)com> wrote:
>
> On 03/15/2016 01:17 AM, Amit Kapila wrote:
>>
>> I have updated the comments and changed the name of one of a variable
from
>> "all_trans_same_page" to "all_xact_same_page" as pointed out offlist by
>> Alvaro.
>>
>>
>
> I have done a run, and don't see any regressions.
>
Can you provide the details of test, like is this pgbench read-write test
and if possible steps for doing test execution.
I wonder if you can do the test with unlogged tables (if you are using
pgbench, then I think you need to change the Create Table command to use
Unlogged option).
>
> Intel Xeon 28C/56T @ 2GHz w/ 256GB + 2 x RAID10 (data + xlog) SSD.
>
Can you provide CPU information (probably by using lscpu).
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haribabu Kommi | 2016-03-17 03:41:57 | Re: Parallel Aggregate |
| Previous Message | Haribabu Kommi | 2016-03-17 03:30:52 | Re: Combining Aggregates |