Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0ER8-0007uf-R0 for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Sep 2018 23:20:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g0ER6-0005NI-3m for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Sep 2018 23:20:40 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0ER5-0005NB-TM for pgsql-hackers@lists.postgresql.org; Wed, 12 Sep 2018 23:20:39 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0ER2-0008LI-RQ for pgsql-hackers@lists.postgresql.org; Wed, 12 Sep 2018 23:20:39 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w8CNKX0i029347; Wed, 12 Sep 2018 19:20:33 -0400 From: Tom Lane To: Michael Paquier cc: pgsql-hackers@lists.postgresql.org Subject: Re: [HACKERS] Cutting initdb's runtime (Perl question embedded) In-reply-to: <20180912224408.GB1387@paquier.xyz> References: <20180509153924.32kvslqeqdyco7c5@alvherre.pgsql> <8873.1525881373@sss.pgh.pa.us> <21138.1525969099@sss.pgh.pa.us> <25428.1533925885@sss.pgh.pa.us> <20180912073701.GM25160@paquier.xyz> <949.1536760821@sss.pgh.pa.us> <20180912224408.GB1387@paquier.xyz> Comments: In-reply-to Michael Paquier message dated "Thu, 13 Sep 2018 07:44:08 +0900" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <29345.1536794433.1@sss.pgh.pa.us> Date: Wed, 12 Sep 2018 19:20:33 -0400 Message-ID: <29346.1536794433@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Michael Paquier writes: > On Wed, Sep 12, 2018 at 10:00:21AM -0400, Tom Lane wrote: >> I believe that this patch will never make for any functional change, >> it will only give you some other alias for the zone it would have >> selected anyway. > Looking at the list of aliases, I am not seeing listed countries running > across multiple timezones, so that may be fine. Not sure what you're worried about. "Linked" time zones are the *same data*. In an installed tzdb tree, the Japan file is either a hardlink or symlink to the Asia/Tokyo one, so they can't differ. What you seem to be speculating about is actual errors in the tzdb data, ie not describing the facts on the ground in particular places. That's possible I suppose but it's hardly our problem if it happens; it'd be theirs to fix. regards, tom lane