Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gePUr-0004xJ-07 for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Jan 2019 19:14:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gePUp-0000Lc-O8 for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Jan 2019 19:14:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gePUp-0000LU-Dl for pgsql-hackers@lists.postgresql.org; Tue, 01 Jan 2019 19:14:35 +0000 Received: from mail-wr1-x443.google.com ([2a00:1450:4864:20::443]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gePUm-0004BS-AH for pgsql-hackers@postgresql.org; Tue, 01 Jan 2019 19:14:34 +0000 Received: by mail-wr1-x443.google.com with SMTP id s12so28665684wrt.4 for ; Tue, 01 Jan 2019 11:14:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=to8SwlQBIqMwN4t9GZ0UqOXLwofthsqLGYuDLRpQmwc=; b=wlTGmAzQ0B+wG13ROez11BAKEjtOBw+tu3RvunYOBH9ySTLeZctkO3kY1XAnjrRr9y 66xRntXVg+hdpX1CUkf+jIBtbeJq0ywn78lMPtC+hRCoAIxyIoS9rEU2+PUZJ4PoglEG +7nRZdX72iJCyUetszxMG1sMPu6Gmj0tmUtUcnSwaUkU0Jc4SyvKuIPSMx3CUtkJz9/p E5tq7LJdgahR3t4SSx9qEefDNVR94mD2gLzk0m8naje0jF/tTgGZptzbEpHnkP+95n+c jmRMFJDdDlfq+h9anmRrt5Q7wj+DpoYmDTclKSS/PFio9B50xYdmWWSdZJG1iDxcQiN3 rBDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=to8SwlQBIqMwN4t9GZ0UqOXLwofthsqLGYuDLRpQmwc=; b=nck3NQr39HBDDK1vyywOP3Gz47XspsuclZDVmwLxS8KsJHx/zt5aKmLJqSSxD1ltTn +cmzM/otT6E6zzuBnAgXcWRQQhIBvA1Fkr1qGFJaMP/3PD9ZiEtOUSXiHE/hS/Sj+7Qp l3O1X/xDcyG4x1GCGeicNngctY367iJDqPDRuRjzClml0QayXMGjoSqc4DfuOEJU63e1 Xq/Ck12YYxFEJTRsBHidXFh0vpFPfcfQAfVXHK5UXoGfdPh/BxcZ3NG0bEzZkVntF2My jeVfZzvcYQ9TbBmh4gWNxJ2EcnAHs27neF/FqabM83LDWmUSMkDPAgj+GhbOIxJERVml SGeg== X-Gm-Message-State: AJcUukepp/LrvjWAqLZjmvCWBqXlqU9oju5uqUTKKMCll5QGwj9BV0t6 UUCDk+dYLRsbTa8EY9YSTorwhIwnSJY77A5ttyhiRW8OmxJwEWPSPXIT8LqpFcrtQLEVPNiT5XY lbzIa75QOlkT99UnEXwW3vpMUdrspKlJ8URHQA0Oiu3NhJxokp0tewJENrneyTvzozBpz4ECok6 ZaGCGBwxVKZjiFWA== X-Google-Smtp-Source: ALg8bN4STFo38/nbSr0ihtvOuNxqbHC3jb0AgQkSivol5pbJoUTU5P/+UID9IR3YSfB0aM9njWP1sQ== X-Received: by 2002:adf:f052:: with SMTP id t18mr38602366wro.112.1546370069376; Tue, 01 Jan 2019 11:14:29 -0800 (PST) Received: from [10.137.2.19] (ip-86-49-251-50.net.upcbroadband.cz. [86.49.251.50]) by smtp.gmail.com with ESMTPSA id n20sm28013015wmi.11.2019.01.01.11.14.28 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 01 Jan 2019 11:14:28 -0800 (PST) Subject: Re: shared-memory based stats collector To: Andres Freund Cc: Alvaro Herrera , Kyotaro HORIGUCHI , ah@cybertec.at, magnus@hagander.net, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org References: <20181129121819.5vgq7fuohkheq7wu@alvherre.pgsql> <854d6d91-f2f3-e391-f0fc-064db51b391e@2ndquadrant.com> <20190101180318.xikb6b4nm57pjtju@alap3.anarazel.de> From: Tomas Vondra Message-ID: <54232a9d-0bba-2bc2-6ed2-70598372459c@2ndquadrant.com> Date: Tue, 1 Jan 2019 20:14:25 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.1 MIME-Version: 1.0 In-Reply-To: <20190101180318.xikb6b4nm57pjtju@alap3.anarazel.de> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 1/1/19 7:03 PM, Andres Freund wrote: > Hi, > > On 2019-01-01 18:39:12 +0100, Tomas Vondra wrote: >> On 11/29/18 1:18 PM, Alvaro Herrera wrote: >>> On 2018-Nov-28, Tomas Vondra wrote: >>> >>>>> v10-0004-Shared-memory-based-stats-collector.patch >>>>> updated not to touch guc. >>>>> v10-0005-Remove-the-GUC-stats_temp_directory.patch >>>>> collected all guc-related changes. >>>>> updated not to break other programs. >>>>> v10-0006-Split-out-backend-status-monitor-part-from-pgstat.patch >>>>> basebackup.c requires both bestats.h and pgstat.h >>>>> v10-0007-Documentation-update.patch >>>>> small change related to 0005. >>>> >>>> I need to do a more thorough review of part 0006, but these patches >>>> seems quite fine to me. I'd however merge 0007 into the other relevant >>>> parts (it seems like a mix of docs changes for 0004, 0005 and 0006). >>> >>> Looking at 0001 - 0003 it seems OK to keep each as separate commits, but >>> I suggest to have 0004+0006 be a single commit, mostly because >>> introducing a bunch of "new" code in 0004 and then moving it over to >>> bestatus.c in 0006 makes "git blame" doubly painful. And I think >>> committing 0005 and not 0007 makes the documentation temporarily buggy, >>> so I see no reason to think of this as two commits, one being 0004+0006 >>> and the other 0005+0007. And even those could conceivably be pushed >>> together instead of as a single patch. (But be sure to push very early >>> in your work day, to have plenty of time to deal with any resulting >>> buildfarm problems.) >>> >> >> Kyotaro-san, do you agree with committing the patch the way Alvaro >> proposed? That is, 0001-0003 as separate commits, and 0004+0006 and >> 0005+0007 together. The plan seems reasonable to me. > > Do you guys think these patches are ready already? I'm a bit doubtful, and > failures here could have quite wide-ranging symptoms. > I agree it's a sensitive part of the code, so additional reviews would be welcome of course. I've done as much review and testing as possible, and overall it seems in a fairly good shape. Do you have any particular concerns / ideas what to look for? regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services