| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
| Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>,pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Speed up Clog Access by increasing CLOG buffers |
| Date: | 2016-04-01 20:39:23 |
| Message-ID: | 2F91B844-D053-4FC0-A43A-50659DB95719@anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On April 1, 2016 10:25:51 PM GMT+02:00, Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> wrote:
>Hi,
>
>On 03/31/2016 06:21 PM, Andres Freund wrote:
>> On March 31, 2016 11:13:46 PM GMT+02:00, Jesper Pedersen
><jesper(dot)pedersen(at)redhat(dot)com> wrote:
>>
>>> I can do a USE_CONTENT_LOCK run on 0003 if it is something for 9.6.
>>
>> Yes please. I think the lock variant is realistic, the lockless did
>isn't.
>>
>
>I have done a run with -M prepared on unlogged running 10min per data
>point, up to 300 connections. Using data + wal on HDD.
>
>I'm not seeing a difference between with and without USE_CONTENT_LOCK
>--
>all points are within +/- 0.5%.
>
>Let me know if there are other tests I can perform
How do either compare to just 0002 applied?
Thanks!
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-04-01 21:14:41 | Re: More stable query plans via more predictable column statistics |
| Previous Message | Jesper Pedersen | 2016-04-01 20:25:51 | Re: Speed up Clog Access by increasing CLOG buffers |