pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: David Steele <david@pgmasters.net>
Cc: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Jakub Wartak <Jakub.Wartak@tomtom.com>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: WIP: WAL prefetch (another approach)
Date: Wed, 21 Apr 2021 22:15:07 -0400
Message-ID: <898412.1619057707@sss.pgh.pa.us> (raw)
In-Reply-To: <20210422013411.tbcaqqq6c23s2pxy@alap3.anarazel.de>
References: <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-4! ZSuiAvKiPqDtRQs+yFD9ew@mail.gmail.com>
	<CA+hUKGJKDibdw5HzOdgh+tFsA7=wwJ3O6p+qYwbgAD_xkLWA3Q@mail.gmail.com>
	<CAOuzzgrn7iKnFRsB4MHp3UisEQAGgZMbk_ViTN4HV4-Ksq8zCg@mail.gmail.com>
	<892344.1619054465@sss.pgh.pa.us>
	<20210422013411.tbcaqqq6c23s2pxy@alap3.anarazel.de>

Andres Freund <andres@anarazel.de> writes:
> On 2021-04-21 21:21:05 -0400, Tom Lane wrote:
>> What I'm doing is running the core regression tests with a single
>> standby (on the same machine) and wal_consistency_checking = all.

> Do you run them over replication, or sequentially by storing data into
> an archive? Just curious, because its so painful to run that scenario in
> the replication case due to the tablespace conflicting between
> primary/standby, unless one disables the tablespace tests.

No, live over replication.  I've been skipping the tablespace test.

> Have you tried reproducing it on commits before the recent xlogreader
> changes?

Nope.

			regards, tom lane





view thread (174+ messages)  latest in thread

Message-ID: <898412.1619057707@sss.pgh.pa.us>
Permalink:  ../898412.1619057707@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/898412.1619057707@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, andres@anarazel.de, thomas.munro@gmail.com, sfrost@snowman.net, alvherre@2ndquadrant.com, david@pgmasters.net, 9erthalion6@gmail.com, Jakub.Wartak@tomtom.com, tomas.vondra@enterprisedb.com
  Subject: Re: WIP: WAL prefetch (another approach)
  In-Reply-To: <898412.1619057707@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox