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 1nnoCi-00025E-Be for pgsql-hackers@arkaria.postgresql.org; Sun, 08 May 2022 21:12:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nnoCg-0000Kr-UH for pgsql-hackers@arkaria.postgresql.org; Sun, 08 May 2022 21:12:34 +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 1nnoCg-0000Ki-GG for pgsql-hackers@lists.postgresql.org; Sun, 08 May 2022 21:12:34 +0000 Received: from mail-qt1-x829.google.com ([2607:f8b0:4864:20::829]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nnoCc-0004Oh-Mc for pgsql-hackers@postgresql.org; Sun, 08 May 2022 21:12:33 +0000 Received: by mail-qt1-x829.google.com with SMTP id o11so9749833qtp.13 for ; Sun, 08 May 2022 14:12:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=aMtyz5X2zFHCnOnuu5J/aIhv24y0PtJsV2X/DktLPFo=; b=rdMDT1jllMDB9W5++Pg9N3VRLYR5PMD5cuQOve5jaMWlqkYf99pibY+1j4pPWUcxGj HVjnpe5kqNCEkjnzzF6d1u21FQEdsYGS7TH/IqU5qQGc4MY8w9BS7j+yrx+P9WJVO5XN 0GNe8T7m8kmerjOS1NEPGXDUb89PuhBvo3YpG/K+nzRu8ipJXDpCgWfzrXyuhUNIa61b kk3re1dH5GkoTynKHGxc6cfqPXnjRktI1h7/wiTkI9l+gGMyLfIvZf054TUltatIOYEU rG6nY7rNW+a0F+5+SHjQAOQzXU/2EsCpY6wQ9qGmdyE0Qs9ng3B0zr62fardGcVTr3bX sP5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=aMtyz5X2zFHCnOnuu5J/aIhv24y0PtJsV2X/DktLPFo=; b=ST/mjZ6HT9HPgibHnRfkbVxzJNEQytEtvwNmSAyeabUbh0x8/pEVDke9eRPy2rLt7v kT3pFIp8iB5ZoPxp4fTsQfqSteWaZKA3RQjDvadwd1hUfSaO6e8PM0oQlb78NOO1gYI1 MJ83McaBTEf24MFMTPzqduXlAQl9p1OE9ikI9hrtOyz5J0zaXaP1GsZ+DVlj/rRkQoCw 5EgIdphrMlje0m9K07o9bmBSBBa3daPCqKTIf9QdccwfzONf6h5XZEmocDmQdUb6O7Fz 8U+mhDBcx1/zYWDJAlRj2zCgNRBAO75WQrBjLASJMOC5zXCulhnhUO+PzRS52AoORIYe RPBg== X-Gm-Message-State: AOAM532Kyi12mmmH3Ek29EUSa0ExQYUP4kA6edE5rCbMfGoITy+hJ2eY JxHmY9dUTJRKBcziUScM+Ai/Iw== X-Google-Smtp-Source: ABdhPJyXZV5XYEzolRJFzjdUDW78XZKjPhfLCPo5FQRxRJ8PZXvJErp9leCzLvhn0s/gG5FjkJ3Ijg== X-Received: by 2002:ac8:5b53:0:b0:2f3:935e:77c0 with SMTP id n19-20020ac85b53000000b002f3935e77c0mr12592143qtw.645.1652044348749; Sun, 08 May 2022 14:12:28 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id n23-20020ac86757000000b002f39b99f6b8sm6245957qtp.82.2022.05.08.14.12.28 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 08 May 2022 14:12:28 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 5F54E800567; Sun, 8 May 2022 16:12:27 -0500 (CDT) Date: Sun, 8 May 2022 16:12:27 -0500 From: Justin Pryzby To: David Fetter Cc: pgsql-hackers@postgresql.org Subject: Re: Finer grain log timestamps Message-ID: <20220508211227.GP28830@telsasoft.com> References: <20220508204451.GC11333@fetter.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20220508204451.GC11333@fetter.org> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, May 08, 2022 at 08:44:51PM +0000, David Fetter wrote: > CREATE TABLE postgres_log > ( > - log_time timestamp(3) with time zone, > + log_time timestamp(6) with time zone, Please also update the corresponding thing in doc/src/sgml/file-fdw.sgml It looks like the patch I suggested to include a reminder about this was never applied. https://www.postgresql.org/message-id/10995044.nUPlyArG6x@aivenronan See also: e568ed0eb07239b7e53d948565ebaeb6f379630f 0830d21f5b01064837dc8bd910ab31a5b7a1101a