Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgPz3-0002Dc-OL for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Feb 2017 06:01:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cgPz3-0007v0-9S for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Feb 2017 06:01:01 +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 1cgPxV-000637-3e for pgsql-hackers@postgresql.org; Wed, 22 Feb 2017 05:59:25 +0000 Received: from mail-cys01nam02on0056.outbound.protection.outlook.com ([104.47.37.56] helo=NAM02-CY1-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 1cgPxQ-0001uH-Ou for pgsql-hackers@postgresql.org; Wed, 22 Feb 2017 05:59:24 +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=tK4sa42pTg+t5v4Krus/xwXGojPvliZUV72WwP2Wm5g=; b=PsKcPFM5h/FVVg4i0XvFHmdOGDr0Qt3JYVUHMH9zQazC/wrtcXoYDhkUkU7g+jafFWw1TwWsQJeZng4gterI1lDLdykj2qZ6hC0n3OGzXSgfVcWa1ECG9K8H+FZul5FKsbzuO9wQeuOwmRUnhWBt7jZ2EQUkfayF6lQb6yqJvvU= 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 DM5PR11MB1641.namprd11.prod.outlook.com (10.172.38.12) 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 05:59:15 +0000 Subject: Re: Replication vs. float timestamps is a disaster To: James Cloos , Tom Lane 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> <31590.1487599653@sss.pgh.pa.us> CC: Andres Freund , Petr Jelinek , Robert Haas , "pgsql-hackers@postgresql.org" From: Jim Nasby Message-ID: <7b94f406-0cc0-20d6-f6e8-e677e6e8adb2@BlueTreble.com> Date: Tue, 21 Feb 2017 23:59:09 -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: 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: BL2PR20CA0041.namprd20.prod.outlook.com (10.167.113.179) To DM5PR11MB1641.namprd11.prod.outlook.com (10.172.38.12) X-MS-Office365-Filtering-Correlation-Id: 23ec14c0-7d1d-435a-ce3e-08d45ae7ef7a X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:DM5PR11MB1641; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;3:infln0HfL4Y/fXekxmKpEth3SJ+PRe9ABKRQC/T94R4nlXGnLeQ07WYi4tZp4EUe+a2OXR+dCfQuxIiR4RN4DFXg18QLHY5I0FN5FXACqngUfJnGpMMXOrkGAPltImnDsZY2zhbqTX7cXoslFvtSc70O+GEd9OB8Sp/pj1Zb6LJ5iO3aT/X1Pw16qeFbM/ZRmgob5EODiTbs2OYoqYIxDiVIJW+eF8hYliQSSadC8yX/AEU7PLe6TyPUkKJkM3SfRAOoEo0b1pp18ERYayEolQ==;25:BpCddsZ9T1w4qKVGY+HSx7fWt82P5dHCwZnjXgteQ8Sfm8G1rEseG2CwAkI4itZJBw3ZcNgXQg3hrrCzeaDBEebBCcLZWosSNdqms9Kkb9gwchnoQGv93QXZMSTRwodSf9qe6p+DEtr6pcgi4KG/SF9+7i9ISklq56X+neORW1jmF35MHMYuFdpq6Lg1vkFOkxSwam+JG2aCcMn/PP4DzWfysgq3Z5dZuunLrOvpxn5eKYvDoeKt13qR2vy1zjXdr37KMesVigH37krzQyyE/RCv69K3s5YEUQJjeW+opzznqjuFmhOZ4VIc5bIJGOaputqk6wSGwfCn/CoF3Q5yPVwz1cQmuo+NOyR0IilSJqdYjrn26xE9sFZjOpci7zblOQc1CHFxhJnf79LygyMCibYH95Bh0FhgZ9T3B6kWf9mvGQ/OCacvVzut7kVeIXpXto3BvRmvepwDeqi2Hv9Llw== X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;31:/KUN5A1V8YORAKpGLjLKpyVtTyudtu2CmEdpbvo7GjapqpVPDsynqW2+gcs0Xq8NYn/oyQuvyTwNswfI8LPcAGsdMFypAmfyuy9cQvnq6TIUQBIlDtmitHKs13SxjZ/c7hlr8VF7mHf6jWXZ+/alZ/BOfp8ywEVv1MXoGeD3SYMM8WAy9HIsMvnGXKPPYp0SIC3kLQLSZ1arhuLJtXBjzhImYGSp+iULnajrx0blh4FMttfki1aN6JaRNTKYRhy+5wWKAqrpC0j+vZJ6UG5rBc7UTZ0BsAvEuTCGs0ey7CY= 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)(2016111802025)(20161123560025)(20161123562025)(20161123555025)(20161123564025)(20161123558025)(6043046)(6072148);SRVR:DM5PR11MB1641;BCL:0;PCL:0;RULEID:;SRVR:DM5PR11MB1641; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;4:AE1mg9Kzq3+MeZaIkOKYJ6Fsz66IJ99FXGMzyHpCqThAsIKwvLJgtk+Xz4UAObjBX0JX3KQ+Z78rm9e5GcBxMtXnsZ1h+hb/mt5HikyCBxi+n6QpY/m63bNXbdLiU49GybvTROOQo7KOlDqc8aD5wWVp9SsWGspM50YZY4Nqk9WO5Fxed+XUTIHBLBFuQrUb0SeFBr4SMWNiYA3LXwdLR+r/MDlHEOzdYtjs75wkeyHnlhG9/Xv/eHtGvSgLqwoGxhc1j0C6RiHndEFXsayjhbXz5dNXH23ILLOvyXm6Ktm4H5EiVJ+98zYRI+R0x7LEnOCGnAXf8UFee9KXGBmMByxqR3o5/hELY067P/6E2sMwRhBW+519HyUzQ+mABWGu5H3TEqv3P0jutlhU0F/8q1H8U1cU2D93pss4Hwkyb/hkVfGcu1jXtT5ihm8Uo/PAydP8drZBWMp7U7Ltkpen8ZiM69Yi2Q+lFIb3WtwCq4dkr4hP9AcDC+1wZskt44M7K5FywwnRi52pmHd0DWp4T8TeC3SPPxKarY7J42wIA82XyBXtAMbBaPYnleDjrmpcadukRqTV1JXo5d4wPcFohIBAvUjjph+YeS9iJODlogJwgMpOS7J8SzrkQqSTsxSY0Tz74F6HJDTbR0Xsi4mTplviJo2MFpjYvmVdJ37oq4A= X-Forefront-PRVS: 022649CC2C X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(39450400003)(189002)(24454002)(377454003)(199003)(25786008)(305945005)(81166006)(6486002)(7736002)(81156014)(6306002)(8676002)(54906002)(229853002)(53936002)(53546006)(101416001)(6506006)(189998001)(966004)(6512007)(36756003)(65826007)(97736004)(6666003)(5660300001)(33646002)(2950100002)(93886004)(47776003)(83506001)(4001350100001)(50466002)(68736007)(31696002)(4326007)(65806001)(23746002)(53416004)(76176999)(106356001)(86362001)(54356999)(42186005)(38730400002)(92566002)(69596002)(6246003)(6116002)(53386004)(31686004)(105586002)(64126003)(65956001)(50986999)(230700001)(2906002)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:DM5PR11MB1641;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;DM5PR11MB1641;23:T1rgYfE6slY1iQhWsF+VEM52sB27sovyMM3L0?= =?Windows-1252?Q?xUV+U8X25afdpcUuTAwRQ7IrWCgrG95BFkh1fs4EIWAPo5TIl8dFYRR9?= =?Windows-1252?Q?gG1HfXBqbgZyHNqThFQaIACbj999+FuL4oVu1lfMbOrOoDoPSQY98yGA?= =?Windows-1252?Q?/foDFNoIKrXSZGraGnuJVn76JlfFA0fPsLWl3Tdr/X6DYyYP7rTyjdfQ?= =?Windows-1252?Q?gDGHpcJWHWHyPsv+iRNSujSD6y56aSsZcFEbXaxCB4AnvzBKxaKeDYUS?= =?Windows-1252?Q?ozfihz30x4cHPe3oZYB6kRbZeQqi5GI8BiHL6yVHCNT8WJ8eq29iPix1?= =?Windows-1252?Q?GQTwd+G5tBkQgaEnLra/PAkJyCtXgt9R07BOILBKuWczyXen21EgdsvT?= =?Windows-1252?Q?zgdjmxrTkHqIvHFQrcJOR67Z8OEp9q7ugrDXFMalRM6EIM6dS4ro+vJV?= =?Windows-1252?Q?AJfOg3sR+VtY9vWouTIdpzTVSx3hpzJJJ20tyPDF3C4U3sz0bZSbojTc?= =?Windows-1252?Q?8ER8nBZBYN3Dvks9ilsS3LcchvS5dv8qsTTXkfu5+/fHUilX1iCkM1cn?= =?Windows-1252?Q?XeFHhgn3hxJg0BkbeMAvu+28fQAVPM5UQ9OmcMJLMtPP7S0J+SkMpx7l?= =?Windows-1252?Q?ai0ESogcqtAbCVIUMBEnO7O9klOSzAw7MiknfpAbg9cpZs+gvni+AlR/?= =?Windows-1252?Q?h75rf3KHHx9zkttxFuYpsNj7NbDeUAR/4VJJkbqO8i/0CP1wehpWu4/P?= =?Windows-1252?Q?soBLOSJErE8YG+9wawQBcTG90pBs9M3a2nmh1J/JLt8I3/Tsgi7woe5a?= =?Windows-1252?Q?FiFtgl1bej7WcPncKw9W9TO0KPRboNBvd6PpkpcdvXz6KXeXVcU5vrFG?= =?Windows-1252?Q?8DSeF+WT5EHHPXKSC6ejAABiRpH6ggo13qZ5by0Ssdm86ovrZlHr/yAy?= =?Windows-1252?Q?foLolG7AG8pwfOtp9KkShXKmuICytTaieWmk08ekAdP62zc51G4YTyFn?= =?Windows-1252?Q?GXd5w8tO7gktKaYTZsY1FOL3oX0CFGF36Sqzp5SjZZ66JuXLTOckYI8E?= =?Windows-1252?Q?NTUlEFHZOzMsEws2WplnX6s9MOLQXA/TsvmgPuTNMUGezhy8DxdADXlM?= =?Windows-1252?Q?Jwi6L/SofyUMWpmgdnHW2STdMg+gSY9iqt3WP1Ur14P3Qia8QxP3lygm?= =?Windows-1252?Q?cUfkB7ZtGJtr4AQrJBcH4tH8S/DtbO5PQ/TrXhlnXezddk+w9EY1aoha?= =?Windows-1252?Q?4ckrDJF2MCriZ0gq4IeObcuxFtSRK9RYz/BYxF3hQgCNnc1fgc9pJWTK?= =?Windows-1252?Q?eF6OjU82TYbXxXEzP6gkuFIVZ3tfHTrMs9AUnt7AqBeSjy84+HlawMH0?= =?Windows-1252?Q?K+QS5QqJYikC0zkCwX+B9ETYmD4fYFAS++ZgzdIYIoJIgSpWsNUcLvq+?= =?Windows-1252?Q?Nof0jogssrbSIAa8X+Xs7WAQJ3lIIaFQCCmw3Y06YHfI9UAxt3EBgBb/?= =?Windows-1252?Q?lfQ5RaxMcsMKYKC6FXXTOQuYBuJ8YMlgkkwlZwNAVy1aorFbdF5xM3x1?= =?Windows-1252?Q?eLYVwB5XVXvv9aGFIbP+6OlFMQg5FwBKN9v?= X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;6:L9inJaaHZJlCLeC8HB0lHSzfjh0Wj1KXNJREqBLMSJXNiHLdEC28Mhi+zNPQGIr8XPjmNbzev8uVsNf0zU9rCyv5s5OLDxhSyBcuBYyEHjB1ZMuwyY3W3SQoL/YOCibI1CO6UJiV5ZO4JwzttI4Os1oy4RzAb2Zrys7sERmbWV6lgHK+uqnaffeSqqHPmywNNqttUfOueMXOCPFRX0A9yCK9jelYHeAxvFOM5ASdSgGVQlONBMzQhSzICWv2Cz79a75DhL1vV5of/b5iESg/KEqqMpZHvZpT2aVFSfzIdjR9x2NGA9coFgjmxPpMU+On+Xi3HEWEImn3VzfOB07ouPW7bzVQc7CfP9TWem4z071yxvBRjqZElOexjrVVUW2ph6oM+6dAqweBu134TapGNw==;5:jZ522RCuB90qVbwVuAOb1o14acPE+qUxwjRze9R0RNw1FgC//jtwQLJzyvP2B5Sjw9J4DoP8Ue6iauLmmCuR08dtE8HaYNKuzzUv44fa9/YiK444V9fUjZU1gztOqz29pUVatZebRfqEuYppClxmLLnNZUevOvmDOpkNjPbCLAk=;24:tdbzfy/pN/w3CkZuw970lbFQtgr4kHoIvN8wHa9awgPy5fq32XlkvFiBkc0MK32/jv+fUBHFHotSsi+oTozXv2MFBOSi9sTjxU/kdPVbMQw= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;7:i8rgbsK6JnVBow4gXgXqX5Rz9Ko8SGbL+Kgw76jiayr7M7daWPnginN9M86+K4J7XEb5F9lsD1qU6rT0kQzfjqhO+QyFVls99JW62K0F3lQACZZZWBRsmmxMQcBHMJNtHpEP6fiPtgFEWHz304Vabvh/q6FhpQLmvqcwetmM94AXvpJeWQMY9PCUc9DgIlPKfrZmevqyOXcEdLiM8Mnmojo2fSEEpAVSiHGqJeSHXS+9hDd+XLjxZbI+53cYgV2ozcrPpCCjLaMYsCjr0AuFeZiP2ZD7KBEN7KF3STzUTH3XFSLA5gzE08FgfWvWgvMHtRIWYmt63uZ+OwKD0OP7pw== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 22 Feb 2017 05:59:15.6821 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR11MB1641 X-Pg-Spam-Score: -2.3 (--) 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/21/17 4:52 PM, James Cloos wrote: >>>>>> "TL" == Tom Lane writes: > TL> The question to be asked is whether there is still anybody out there > TL> using float timestamps. > > Gentoo's ebuild includes: > > $(use_enable !pg_legacytimestamp integer-datetimes) \ FWIW, last time I looked it was also an option in FreeBSD's ports, though I think it's defaulted to int since forever ago (like, 7.4 era). -- 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