From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <stark@mit.edu>
cc: Thomas Munro <thomas.munro@gmail.com>,
        Tomas Vondra <tomas.vondra@enterprisedb.com>,
        Daniel Gustafsson <daniel@yesql.se>,
        Stephen Frost <sfrost@snowman.net>,
        Alvaro Herrera <alvherre@2ndquadrant.com>,
        Andres Freund <andres@anarazel.de>,
 David Steele <david@pgmasters.net>,
        Dmitry Dolgov <9erthalion6@gmail.com>,
        Jakub Wartak <Jakub.Wartak@tomtom.com>,
        Tomas Vondra <tomas.vondra@2ndquadrant.com>,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: WIP: WAL prefetch (another approach)
In-reply-to: 
 <CAM-w4HNjC=jAbo6EM_itppX7fWkmPWihGz5iM=mim32P-fSuNA@mail.gmail.com>
References: 
 <CA+hUKGJ1=pOiNjSgXYJnjE3OyRtp8tjMRcON256e5EFpzPpgtA@mail.gmail.com>
 <8dd2dcc2-0b6b-a4ab-c1b3-032c0a5ab1c3@enterprisedb.com>
 <CA+hUKGKmkKfH1h9XG5ctYCgqeOHGdN5bHMoQMZLR=+kLY0PQzA@mail.gmail.com>
 <CA+hUKGLsF8sEE+n3qoaV6+XjmYEwYoFVDbLPbYTGz7oGkL=iZA@mail.gmail.com>
 <CA+hUKG+a4wn7B-qBu9SLc1HAbZRSKbp1Ep=rDeveM-UQz84+jg@mail.gmail.com>
 <773932.1619022622@sss.pgh.pa.us>
 <b971373e-5f05-e691-d83c-c72a4f67167b@enterprisedb.com>
 <CA+hUKGLQqsNBXXZ6uXFi7L9iqx-4ZSuiAvKiPqDtRQs+yFD9ew@mail.gmail.com>
 <CA+hUKGJKDibdw5HzOdgh+tFsA7=wwJ3O6p+qYwbgAD_xkLWA3Q@mail.gmail.com>
 <CAOuzzgrn7iKnFRsB4MHp3UisEQAGgZMbk_ViTN4HV4-Ksq8zCg@mail.gmail.com>
 <CA+hUKGKLakuWXsHuOXYYYyk-CiZKgcqXgzwKb61d9nrpgn5eww@mail.gmail.com>
 <5B6070FF-5869-4A84-88BC-2D04EDCDB858@yesql.se>
 <CA+hUKGJ7OqpdnbSTq5oK=djSeVW2JMnrVPSm8JC-_dbN6Y7bpw@mail.gmail.com>
 <a6915477-c675-7959-28b2-5b8fa60f44fc@enterprisedb.com>
 <CA+hUKG+NRzF7qPdjrJg3OqvfFO-yFCLLTUB9wmVH71zbki3G1Q@mail.gmail.com>
 <CA+hUKGKxvj8g1oL7iGaywoe0E-bNSbSPVtS!
 WZ05CnUNWJzEJtw@mail.gmail.com> <477464.1637981215@sss.pgh.pa.us>
 <CAM-w4HNjC=jAbo6EM_itppX7fWkmPWihGz5iM=mim32P-fSuNA@mail.gmail.com>
Comments: In-reply-to Greg Stark <stark@mit.edu>
	message dated "Thu, 16 Dec 2021 21:36:37 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1277418.1639714277.1@sss.pgh.pa.us>
Date: Thu, 16 Dec 2021 23:11:17 -0500
Message-ID: <1277419.1639714277@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1277419.1639714277%40sss.pgh.pa.us>
Precedence: bulk

Greg Stark <stark@mit.edu> writes:
> But if you're interested and can explain the tests to run I can try to
> get the tests running on this machine:

I'm not sure that machine is close enough to prove much, but by all
means give it a go if you wish.  My test setup was explained in [1]:

>> To recap, the test lashup is:
>> * 2003 PowerMac G4 (1.25GHz PPC 7455, 7200 rpm spinning-rust drive)
>> * Standard debug build (--enable-debug --enable-cassert)
>> * Out-of-the-box configuration, except add wal_consistency_checking = all
>> and configure a wal-streaming standby on the same machine
>> * Repeatedly run "make installcheck-parallel", but skip the tablespace
>> test to avoid issues with the standby trying to use the same directory
>> * Delay long enough after each installcheck-parallel to let the 
>> standby catch up (the run proper is ~24 min, plus 2 min for catchup)

Remember also that the code in question is not in HEAD; you'd
need to apply Munro's patches, or check out some commit from
around 2021-04-22.

			regards, tom lane

[1] https://www.postgresql.org/message-id/3502526.1619925367%40sss.pgh.pa.us