Re: patch to allow disable of WAL recycling

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Jerry Jelinek <jerry(dot)jelinek(at)joyent(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: patch to allow disable of WAL recycling
Date: 2019-03-31 02:14:25
Message-ID: 20190331021425.GD10804@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 29, 2019 at 01:09:46PM +1300, Thomas Munro wrote:
>
> ...
>
>I still don't know why exactly this happens, but it's clearly a real
>phenomenon. As for why Tomas Vondra couldn't see it, I'm guessing
>that stacks more RAM and ~500k IOPS help a lot (essentially the
>opposite end of the memory, CPU, IO spectrum from this little
>machine), and Joyent's systems may be somewhere in between?
>

If needed, I guess I can rerun the tests with data on the SATA RAID, but
this time limit the amount of RAM to something much lower.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ryan Lambert 2019-03-31 02:21:18 Re: dropdb --force
Previous Message Tomas Vondra 2019-03-31 01:33:42 Re: [HACKERS] PATCH: multivariate histograms and MCV lists