Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgQ9z-0002cF-Iq for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Feb 2017 06:12:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cgQ9y-0002HT-Dj for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Feb 2017 06:12:18 +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.84_2) (envelope-from ) id 1cgQ8Y-0000ej-2P for pgsql-hackers@postgresql.org; Wed, 22 Feb 2017 06:10:50 +0000 Received: from mail-by2nam01on0089.outbound.protection.outlook.com ([104.47.34.89] helo=NAM01-BY2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cgQ8T-0002Bj-RL for pgsql-hackers@postgresql.org; Wed, 22 Feb 2017 06:10:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=0HbkZXI0XTljsSa772ViuYm4t/B2PrqNuojr9xIa8Hk=; b=g5/mnyAuVSa83I/NpUNzzGom+YaSWleNZRTdiQGkR1HTIvLp9Ns3pIb4jKY+1oCqYFH+H0vOMLOxcZGfB+t2yPU5IbZr3n4/RJG1W1oLhuBpGZCHSSIkPGz1az5X+SnDCAcIRCGFafpiMCteEjJ6dI3tC+tFp7HgaLKSx9KR/wI= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:e483:b2e7:fa67:d256) by DM5PR11MB1643.namprd11.prod.outlook.com (10.172.38.14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.919.13; Wed, 22 Feb 2017 06:10:41 +0000 Subject: Re: Replication vs. float timestamps is a disaster To: Andres Freund , Petr Jelinek References: <26788.1487455319@sss.pgh.pa.us> <1691.1487519369@sss.pgh.pa.us> <20170220070311.gscn7ppqbwlgdpjq@alap3.anarazel.de> <3bd3c551-8b23-45c8-27a2-97b5a922b130@2ndquadrant.com> <20170220110456.2jupmfhxlizykmmc@alap3.anarazel.de> CC: Tom Lane , Robert Haas , "pgsql-hackers@postgresql.org" From: Jim Nasby Message-ID: Date: Wed, 22 Feb 2017 00:10:35 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.7.1 MIME-Version: 1.0 In-Reply-To: <20170220110456.2jupmfhxlizykmmc@alap3.anarazel.de> Content-Type: text/plain; charset="windows-1252"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:e483:b2e7:fa67:d256] X-ClientProxiedBy: DM5PR09CA0014.namprd09.prod.outlook.com (10.172.32.24) To DM5PR11MB1643.namprd11.prod.outlook.com (10.172.38.14) X-MS-Office365-Filtering-Correlation-Id: f7c6205d-afa6-466c-acbe-08d45ae98791 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:DM5PR11MB1643; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;3:k3tz14yJWR61OE/Bu7IlcFFClfSGXlKPuEpswh1Ww5CkaMXkP4YwUxY98AFlC5WdPQWT9dqPSBdbywvLZ4nrWk9dgoG6y6KTwbmSJa4VAgOFznE6HlnSrF/e5GjJNiaOLNH6gLCZ/vpw+EcByBfiJSgZAbdhyKahY+ENNYUACbiZkI4a7frSw6i3OQSdrCZyDSskZOWXbZO2nuEk1G3PeXijAnzVsj5HP2BceC0m5jO6OwFfMuKOVvrJV0EWc/wtrTK656ZzZ2twOSlxtsjwDQ==;25:LfK61Xb+af1aRoOj3WIaXga1KbNlLgI/b8WC/CTYjpGig8C4xoNbrnvUnUEtRj7ZKOJVDypYUpGZzGgH0M3pCUjlu1+MGkYUAx2PBDC70kup8DOjfTjozggvmIBHv+8oJjTB+1GT36H7WSmucu/Tnn8OKxjrVj4pJkA+wO4E5Z3CsrPb718Fdw+UCoSc1nyRoIvenzSbKeY8LyYksaXao/LMgfuJMu0uqjCYuS68IMkFwBltKymh+qzMdmTe5e6zqcDsNr1f11kq4Q2tTWPJdeI+aGonGJ6iph2MCTLciq11VeOsyiT7VtJNgQ0Db29qrVkIGo63QT8bga7WZaDBuD7RSWlNXhLZFyTW5kQ5vX2lcQioLfnUYN8BEyG+qOnwhU7obUiDp50ykNey2yk7xjoYX0vazbQ8VyjNUGLlTO5UKKvgwHhSMxxoKBhBK1wPXSNrLwpx5m15BScIo2cp/Q== X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;31:W8MnzqCCaILYdN5rNr1sQBfvxM3jvZPxRW2XnfaT9r+i0nVMB67F4PunNw72Cd5ovyJujCLyDf8mJrvlwbsAdzdG0eytPe164ZyDh9R6EFQRILPoI8vmOMLiiH6E5weOgArwl0jPEzskk1vuGLUa5QMljD+d1XgajP0dyvW/htvfJwBZtMCebBQOBRQdrJnVnLzXZhTmaNciLXKsvXGPBYdfFMZ8lk+MtgrYnj3EMuxlO/IYWd6/qjZ15d0V/rIRpGo/2BYG/99JLliyohg+uwV+bAGF+uzag76zcdUcKMc= X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040375)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6041248)(20161123555025)(20161123558025)(20161123564025)(2016111802025)(20161123560025)(20161123562025)(6072148)(6043046);SRVR:DM5PR11MB1643;BCL:0;PCL:0;RULEID:;SRVR:DM5PR11MB1643; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;4:9p80hyLZnjzyCXw+bqPcXhUOWx7sAdWyaeb4DcXWwAUmw4/gYzX6Ao7yQa+a9nGmL/M4yk9LyTs4mYYcjxCEAKdZReFeh/upsGKyvO3QuiFh/CzpSvE+n3FTLe/qPfDh+SP+jN88m3e6iaQbGryFSeEKhdyVfJb7aIcZubSwmkPXqxr7azBOvRezCJsA9OQ1F2fujYcolB4sCnDKNoRs/0CXUn/RyRIODBltX6Wbi61BmgpgnN1fIAso2LObyyMA2OyygxUlA4/9PwgtAf7G6A/NmsXfcWUwfqZSM3G3iEhdulQtame2/vMLIfCfyV2Jg7v8D61x6MBekIdRcxOJqdVj96kevAySvUkop2DPgMN9B8XFruAoCtvTEu09PLdipuiVxu3gnK2Jd5PizeiQPle55P/01nUNoO85W7MCbd57+44JxlsIfdjb8J9kI+FV2xG0UNtUd40+9iLN7BUCW/BB8uhBVpSDXotK3i+CJEfsaHn7gDZ8As7kxchzPxQQIbOci7H6h15r/9inPZN75XZJK2R9Up3BA+GuH48U6dXIg9ZYZSgFwALPOjMWLDakKIkxb6RL28VDzvGWOhTLKCXYkHykSF1WszF6tHcXi8KLPAVcL8HNnARkjXmomdDAhwBg9SqnvnN2yyqMVXF95Q5OsCwPYzDQmUjDDr6fJ7U= X-Forefront-PRVS: 022649CC2C X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(39830400002)(39410400002)(39450400003)(377424004)(377454003)(189002)(199003)(24454002)(47776003)(36756003)(54906002)(2950100002)(230700001)(25786008)(4326007)(86362001)(6666003)(6506006)(305945005)(6486002)(7736002)(31696002)(6512007)(2906002)(65826007)(64126003)(68736007)(83506001)(65806001)(6306002)(23746002)(6116002)(229853002)(65956001)(50466002)(69596002)(53936002)(6246003)(106356001)(33646002)(42186005)(53416004)(105586002)(966004)(38730400002)(53386004)(5660300001)(31686004)(93886004)(81156014)(54356999)(81166006)(97736004)(189998001)(76176999)(4001350100001)(8676002)(92566002)(101416001)(53546006)(50986999)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:DM5PR11MB1643;H:decina.attlocal.net;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?Windows-1252?Q?1;DM5PR11MB1643;23:PtB3I26E2Roo3atcWbGGjA30I6mgzYupn46MK?= =?Windows-1252?Q?R4Do06BoFDJUn9E50ai987ixKHr2cxPALcRDGlsbuqDMQ/abU8aMWjOS?= =?Windows-1252?Q?D3W7wUgK7YX0iTb24gl24KY9DKEi3TuwumrEwrISjMhekUQqnhtiD8c8?= =?Windows-1252?Q?jQ9rLiBEf6u7vdR441wmuY+PijSLYT0LDsWcTogk70jDf6EvMqfjX+G4?= =?Windows-1252?Q?9YMFxsOKyorf5dRqssAwInfA6YF1nO6uoUr85zwBgUkJpD8w3oJWGn7p?= =?Windows-1252?Q?GvFNV8OGy/YV0pc3ZhEjnmnuswf9pGmJgFC5ffkDB6cSJjvLDfCqV6+B?= =?Windows-1252?Q?inbW1p1js6nNWUzNcIJ51wncxaZRXbc5H24xmzurDxf1UmMlbtrSrxrK?= =?Windows-1252?Q?Pe5PoibAND+KM9IDUqeHyJXX6VxBJySr3tyfRLg93AEJJ9qRasxYeshh?= =?Windows-1252?Q?CBIfxI9hciyOpb867LvefWi2Vs5BbfK6uW1Ao9Eqn+7R22sc3atwJI6O?= =?Windows-1252?Q?Hcl9Bdu+SaqqSpqAxJ828E6WNPIq3gBIOJoBj1cU7NLJg7DHiJf+JM/b?= =?Windows-1252?Q?4gOwgUbON+f9DKuA4XQNtBwhSSNinK8qDoHx9Npn+sJZnssaJAApVmwO?= =?Windows-1252?Q?GZjN4VV6USeeI79JbxmzAl/Emz4cT8kukkNdI2Q6E6J/p4VwsA8bgfUk?= =?Windows-1252?Q?CHACocJ5LeO9GJeR+TZR/iQhReiZRzWMrT6raLSKESw1IYcxPS4oag/V?= =?Windows-1252?Q?LukoTmOwLH8DSiU575WlRdi1WJPOaqycS1T+mVk6a4Ndf8UlGUQ7jZyb?= =?Windows-1252?Q?3+Z5p8hNFqGBmcfZGV7iXrB8UzZ8Zk4OWE9tVaJZVTO6urAF4yJqk7Rf?= =?Windows-1252?Q?8R+h9J0xwWc4vFhPuWYY+o9VOj54L9Lji0JcGFhVH6RTy2e1lm5XnhYf?= =?Windows-1252?Q?gXCjXLttQ6gnDcT/E7YAhBKAugfbgbNjGS+N554DXlddKXk3eIAe1AIB?= =?Windows-1252?Q?oKW6KL+wm0mX8hERhHUG/0O7gjg+5M/sEul2T68UfUSIRJQhIH85PhgF?= =?Windows-1252?Q?E5zKy3x8xYZxM1OwpKFi4pdbf6eV2tcbCvYgZuoY98oa0lQ4EOZYTMag?= =?Windows-1252?Q?GssU0Z1lqbSNaUX6A/1CbxPnzFEeYanbfyTXyICKVR7G2OOt/tKchbd/?= =?Windows-1252?Q?HsqciEM1UFPDhB7ilOIYFb9mkXx8smeR9hv0lxPMNcbHnO97+M8zbtUP?= =?Windows-1252?Q?PwiP0II+ZRfHjcNw0QdmLpZcMisRw6RzVhvOavhaY+va8eBh4NZkM+05?= =?Windows-1252?Q?nq5KQD55RdqDdXo3MNxiNmUiFFWt+ypcqpfvOoFE4W/Xwy9I4+4i8fW+?= =?Windows-1252?Q?ol/mxUselhoCRe7T/nru7guBC2GOx/FjqwesqhgTciNgeluoi0QGKGnR?= =?Windows-1252?Q?R2AiauMy893TFpIRdI6MnA8jX9DJjG1B8NapP41hPRy7IJWC737mjrHV?= =?Windows-1252?Q?1dNqrO47rvOYUQuBt4l8WjMUgb5tKxtRfOkALL8f1oceiEUqCUblV1iq?= =?Windows-1252?Q?TCu1wwH/9gMAyhMuBXEBoCkrBSMs+X1kYYpGGG4IOAI+wPnDDPfxzx7f?= =?Windows-1252?Q?slKYdEryAYv9m6/rINYxRdJdd1vQrPyva8cgKOwz8oMUwaBRlW07KSV+?= =?Windows-1252?Q?E4XzsZH7A=3D=3D?= X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;6:YsO9xeLJoLvWuH8odi/eiZ3Sx09jqrRhCzEjEhttt1lRgnm4+gpiKzRRKo6XYWufU1rJ9E/llYUDI4l5Gkb1p73oKaFQoPlXbtSrJgnIy+yUl9FFlOQjZw78SxohIFcLCOa+YBpYBmwlLKtv73JmKlva/BVCEFlEAtdeXyY4wvmhttnNiG/tkB03Je1GWJmngO+3Z87z7JOJdHP/eNLqz0EcAhE7FjQMnlRF3WdM1gQ4WkTUnVF+qVmIlmnmR/f+lw9rJ5a6Az116AfkNOP66g+Vt/7a0qAmQIJPCbUityCtA6GLMiR1xpjdbOnpfykHNFhtaZeqd6cwzinDXU5Z+ZJuAfBZ6Q5TWojHysxOHycZ1l/Krb3SZoDKJ1i7sFIM4Ccfef3leGSN+qokVc5ALA==;5:Samg6RpLcf0ocEDjdLnXZ/5vU7Jk8Mu+RZqQoXc+cHiIGNMM5z7MW/8QuVj3QYlPCbrmBWkFec1orteri6dA+rZPfh/qed6WtB5fPrRN5PtVNsSMKkF35FR+9Ih/TQeJQZmgnhdXJ65GUKbEj0hhz5E0h/PElsFkxIzWuRApi4c=;24:6PEtCTj6K1uEEj/4qejTjX8TBMB+CygdTdsxa8yKRCQVKU9oCFedlkUk6FCASJ/uCU4WYqzRhc7ckZYempsQCU/I73LxDGE7DqY6jObMqKg= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;7:5YxXsI+M0gEkRh9dXsGCB7BjAguCsj/lt87mtanaDRjpwt2IwJ2bWVgCVpVK7RdQQ4IQXpYtBVIMEtybF48xTJdwhsUhXo7j3Q49LwA44LRuoX1VJEgVXV1Pbjm1ssNqxxlWWwRBrAOgvYLMsEe51J0TaeG1C+3sFcRsH+pGtlWjbG2imrT5TkkAhAZ97n7gakBlvoQADFSA9p9lfGXvLxN7LwX4crqzMLIiyzPUFRTkNes/BwDNm/iX7wEs/a8rqQEg3gkOU9lKtstbtueRUXiS4YBP2VJzJ6wW3fhPpTQnPPYmHjEi+HNweRZQIcHaB2QVOQh60F3pvHmP2XL7Zg== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 22 Feb 2017 06:10:41.0059 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR11MB1643 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2/20/17 5:04 AM, Andres Freund wrote: > On 2017-02-20 11:58:12 +0100, Petr Jelinek wrote: >> That being said, I did wonder myself if we should just deprecate float >> timestamps as well. > > I think we need a proper deprecation period for that, given that the > conversion away will be painful for pg_upgrade using people with big > clusters. So I think we should fix this regardless... :( I wounder if a separate "floatstamp" data type might fit the bill there. It might not be completely seamless, but it would be binary compatible. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers