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 1h0qs6-00060P-Kr for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2019 16:55:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h0qs4-00081Q-OX for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2019 16:55:20 +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 1h0qs4-0007vl-Bh for pgsql-hackers@lists.postgresql.org; Mon, 04 Mar 2019 16:55:20 +0000 Received: from smtp-fw-9102.amazon.com ([207.171.184.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h0qs0-0000bs-Q5 for pgsql-hackers@postgresql.org; Mon, 04 Mar 2019 16:55:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1551718516; x=1583254516; h=date:from:to:cc:subject:message-id:references: mime-version:in-reply-to; bh=bNXYytM7GfWCAs2FSeEvSrY4AeMj7fIV3FQfKpVbBJ8=; b=A6fvtrVMhAtsCGfg0zB1EFSEU+t6GIhFFODP1e/OH4x4sPV9qkCE6Gpr k/+wl+qa+hZifruu7cxC0oc5fHf2Y/nuqG7F1KoVRydoOzfc20eVIAGWW Efk/xIHE9qq193zn7WOLZ+gDcFDVoV3+hIkVlgdhLRy6NsCiJFR273i7f E=; X-IronPort-AV: E=Sophos;i="5.58,440,1544486400"; d="scan'208";a="663084727" Received: from sea3-co-svc-lb6-vlan3.sea.amazon.com (HELO email-inbound-relay-2a-f14f4a47.us-west-2.amazon.com) ([10.47.22.38]) by smtp-border-fw-out-9102.sea19.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 04 Mar 2019 16:55:08 +0000 Received: from EX13MTAUWC001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-2a-f14f4a47.us-west-2.amazon.com (8.14.7/8.14.7) with ESMTP id x24Gt74Z106452 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Mon, 4 Mar 2019 16:55:07 GMT Received: from EX13D05UWC002.ant.amazon.com (10.43.162.92) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Mon, 4 Mar 2019 16:55:07 +0000 Received: from f01898859afd.ant.amazon.com (10.43.160.245) by EX13D05UWC002.ant.amazon.com (10.43.162.92) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Mon, 4 Mar 2019 16:55:07 +0000 Date: Mon, 4 Mar 2019 08:55:06 -0800 From: Shawn Debnath To: Robert Haas CC: Andres Freund , Thomas Munro , Thomas Munro , Dmitry Dolgov <9erthalion6@gmail.com>, PostgreSQL-development Subject: Re: Refactoring the checkpointer's fsync request queue Message-ID: <20190304165505.GA67539@f01898859afd.ant.amazon.com> References: <20190222235742.4oed46wocpjfpoa5@alap3.anarazel.de> <20190227212653.GA7171@f01898859afd.ant.amazon.com> <20190301174256.3um2t73wycsywrur@alap3.anarazel.de> <20190301193558.GA4664@f01898859afd.ant.amazon.com> <20190301203533.GB4664@f01898859afd.ant.amazon.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.11.3 (2019-02-01) X-Originating-IP: [10.43.160.245] X-ClientProxiedBy: EX13D08UWC003.ant.amazon.com (10.43.162.21) To EX13D05UWC002.ant.amazon.com (10.43.162.92) Precedence: Bulk List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Mar 01, 2019 at 04:27:47PM -0500, Robert Haas wrote: > On Fri, Mar 1, 2019 at 3:35 PM Shawn Debnath wrote: > > On Fri, Mar 01, 2019 at 03:03:19PM -0500, Robert Haas wrote: > > > On Fri, Mar 1, 2019 at 2:36 PM Shawn Debnath wrote: > > > > I disagree, at least with combining and retaining enums. Encoding all > > > > the possible request types with the current, planned and future SMGRs > > > > would cause a sheer explosion in the number of enum values. > > > > > > How big of an explosion would it be? > > > > 4 enum values x # of smgrs; currently md, soon undo and slru so 12 in > > total. Any future smgr addition will expand this further. > > I thought the idea was that each smgr might have a different set of > requests. If they're all going to have the same set of requests then > I agree with you. Yeah, in this particular case and at this layer, the operations are consistent across all storage managers, in that, they want to queue a new sync request for a specific file, forget an already queued request, forget a hierarchy of requests, or unlink a specific file. The fun is at the smgr layer which was discussed in a sub-thread in the "Drop type smgr" thread started by Thomas. I started on a patch and will be sending it out after the refactor patch is revised. -- Shawn Debnath Amazon Web Services (AWS)