Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ktaSU-00065E-TJ for pgsql-hackers@arkaria.postgresql.org; Sun, 27 Dec 2020 18:07:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ktaST-0005Yh-Lc for pgsql-hackers@arkaria.postgresql.org; Sun, 27 Dec 2020 18:07:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ktaST-0005Ya-20 for pgsql-hackers@lists.postgresql.org; Sun, 27 Dec 2020 18:07:57 +0000 Received: from xvm-110-146.dc2.ghst.net ([46.226.110.146] helo=fetter.org) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ktaSQ-0000Dm-8o for pgsql-hackers@postgresql.org; Sun, 27 Dec 2020 18:07:56 +0000 Received: by fetter.org (Postfix, from userid 1001) id A29D341BB1; Sun, 27 Dec 2020 19:07:51 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=fetter.org; s=default; t=1609092471; bh=NeRZeOw5mEh3vaSVCSdceLvZN7ox3cbz1xijtZycHKE=; h=Date:From:To:Cc:Subject:References:In-Reply-To:From; b=rb9E3V8ZUmZADHEeESz55gimsBTU0YqA4AB/eg/CXVOEVR9ialp7NqSsWS+lju/5e OirVHf32k2SswyAdquZNRbde0ZNXwlrHTck+A1ou+ztVO9nXzl377onjKlfG7n1FYR yxL+PtO560nKqLCruBm7P+CQGhbidpX2u3OoK5LuynR3+QbS77g9I13dEpBHwVDpyS oOB3hB8aev30Yyg816AQy61+s1d+whAHnm7zXmg6Dxbi4gAZKqqCGyK9BgSBNCVX6E IxEGfUeaJpoc9v8u2izFM7V4/l2OatlsaYU3Iy2mS/he+bPWYdGfSns9QBM2z1hx3O KocMhpF5V6Muw== Date: Sun, 27 Dec 2020 19:07:51 +0100 From: David Fetter To: Zhihong Yu Cc: Alexander Korotkov , Alvaro Herrera , Paul A Jungwirth , Justin Pryzby , Tom Lane , PostgreSQL-development , Jeff Davis , Pavel Stehule Subject: Re: range_agg Message-ID: <20201227180750.GH13234@fetter.org> References: <20201208000010.GA2786@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sun, Dec 27, 2020 at 09:53:13AM -0800, Zhihong Yu wrote: > Hi, > > This is not an ideal way to index multirages, but something we can > easily have. What sort of indexing improvements do you have in mind? Best, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate