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 1gMalq-0001Su-6b for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Nov 2018 15:38:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gMalo-00034p-Mr for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Nov 2018 15:38:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMaj1-0007qn-9p for pgsql-hackers@lists.postgresql.org; Tue, 13 Nov 2018 15:35:35 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMaix-0007yy-Is for pgsql-hackers@postgresql.org; Tue, 13 Nov 2018 15:35:33 +0000 Received: by mail-wm1-x332.google.com with SMTP id p2-v6so11800280wmc.2 for ; Tue, 13 Nov 2018 07:35:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:cc:date:in-reply-to:references :mime-version:content-transfer-encoding; bh=X1PBLqyinHymaEBZSGJ6LSD7zzmZT5UiReZcRe1thuA=; b=INnxiaGiGsOserDriPEcCa06HgtSIoPDGXtlFxYW4ZSV3AiVDMeUpuXqS4WqoOugeE JrAokIarktKs7xUDEPR/uh/oRqtt4FOgbsQqGGI19+ElYpZae37y8wGB2oImzHI0rtFS 2xvGV0fAXPjfJUlsHVPrwwBvim6yHR9qIbz+0y8g6VBvdSC5Wg1lkenycPqHeRGjFuBR BgE9iYVLWYsJ1YRZ8vXHXgXfHGBEHFx0cz1F1G9Xp/0BqRLW83/HMKsxcjJlaENHbX15 RG4QGd8J4DUKxr5/DDIMMKPFjqAXruvG1QNOJIT40BZCRVpamtcH8qdqcOgILlKgvnUZ gYeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:mime-version:content-transfer-encoding; bh=X1PBLqyinHymaEBZSGJ6LSD7zzmZT5UiReZcRe1thuA=; b=qp81eKL7KdeALnaEDeBLs3f6ZgQluI4SJyNGNpa4o28QgKR06jjizvCihh6K8udrp5 IBvpM5CcK78g05OPu8wV2bJS1tx0+zoNYxnnh84VJlkYrMAggyxnkAKaVzbi+M2/s56D D0u3v9OUlKxhKOvtfFPNtKgAypSWfouN8kL5KF6YvOXA6a4J/bCxB3wf7gyt/zdtLkT1 PfEeUqTLY9MpA4fkZDXAk2m57wtG+wpJFz2Aql955xz3hza6gCgaezPZc3gSoHizpvlA Y59sVxLaAiiVBH/3JXMKCCXBGfnWbW/+6rFatGGZso5/LC4WmKpKMT1zk0WppmfepoCr /rSA== X-Gm-Message-State: AGRZ1gIfgYQgNoRQZUOzh3Y8IL8raUheJlkqrnuuCih4OIEAPkkHzF/p sF0rERkSJZwya7bdLc1JtJ8FVA== X-Google-Smtp-Source: AJdET5fKli+gDWtQPhimH7K04pWeAKdUo7uqOketGBt7IIh0R3+v76EevKsSH/vfcPi+aB+4zdFRnw== X-Received: by 2002:a1c:90cf:: with SMTP id s198-v6mr2830304wmd.124.1542123329947; Tue, 13 Nov 2018 07:35:29 -0800 (PST) Received: from development (static-84-42-175-93.net.upcbroadband.cz. [84.42.175.93]) by smtp.gmail.com with ESMTPSA id v9-v6sm21594416wrm.6.2018.11.13.07.35.28 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Tue, 13 Nov 2018 07:35:29 -0800 (PST) Message-ID: <8e041a34a70ae5d44cb10a7e516308e2f6d1b651.camel@2ndquadrant.com> Subject: Re: shared-memory based stats collector From: Tomas Vondra To: Kyotaro HORIGUCHI Cc: alvherre@2ndquadrant.com, andres@anarazel.de, ah@cybertec.at, magnus@hagander.net, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org Date: Tue, 13 Nov 2018 16:35:27 +0100 In-Reply-To: <20181112.201042.147595779.horiguchi.kyotaro@lab.ntt.co.jp> References: <20181108153941.txjb6rg3y7q26ldm@alvherre.pgsql> <20181109.173315.29453727.horiguchi.kyotaro@lab.ntt.co.jp> <803f2d96-3b4b-f357-9a2e-45443212f13d@2ndquadrant.com> <20181112.201042.147595779.horiguchi.kyotaro@lab.ntt.co.jp> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.28.5 (3.28.5-2.fc28) Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, 2018-11-12 at 20:10 +0900, Kyotaro HORIGUCHI wrote: > At Fri, 9 Nov 2018 14:16:31 +0100, Tomas Vondra < > tomas.vondra@2ndquadrant.com> wrote in < > 803f2d96-3b4b-f357-9a2e-45443212f13d@2ndquadrant.com> > > > > > > On 11/9/18 9:33 AM, Kyotaro HORIGUCHI wrote: > > > Hello. This is rebased version. > > > At Thu, 8 Nov 2018 16:06:49 +0100, Tomas Vondra > > > wrote in > > > > > >> However a quite a few extensions in contrib seem are broken now. > It > > >> seems fixing it is as simple as including the new bestatus.h > next to > > >> pgstat.h. > > > The additional 0009 does that. > > > > > > > That does fix it, indeed. But the break happens in 0003, so that's > > where the fixes should be moved - I've tried to simply apply 0009 > > right after 0003, but that does not seem to work because bestatus.h > > does not exist at that point yet :-/ > > Sorry, I misunderstood you. The real reason for breaking 0003 as > you saw was the result I just removed PG_STAT_TMP_DIR. 0005 fixes > that later. I (half-intentionally) didin't keep soundness of the > source tree at v8-0003 and v8-0008. > > > The current split into 8 parts seems quite sensible to me, i.e. > that's > > how it might get committed eventually. That however means each part > > needs to be correct on it's own (hence fixes in 0009 are a > problem). > > Thanks. I neatended up the patchset so that individual patch > keeps source buildable and doesn't break programs' behaviors. > OK, thanks. I'll take a look. I also plan to do much more testing, both for correctness and performance - it's quite piece of functionality. If everything goes well I'd like to get this committed by the end of January CF (with some of the initial parts in this CF, possibly). regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services