Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4642265042B for ; Mon, 25 Aug 2008 03:13:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92482-05-3 for ; Mon, 25 Aug 2008 03:13:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 9D2556502A6 for ; Mon, 25 Aug 2008 03:01:53 -0300 (ADT) Received: from [192.168.178.24] (p548B20FE.dip0.t-ipconnect.de [84.139.32.254]) by service-web.de (Postfix) with ESMTP id 30068E817D; Mon, 25 Aug 2008 08:01:49 +0200 (CEST) Message-ID: <48B24ACB.8010906@wildenhain.de> Date: Mon, 25 Aug 2008 08:01:47 +0200 From: Tino Wildenhain User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: dforum Cc: pgsql-performance@postgresql.org Subject: Re: NOW vs CURRENT_DATE References: <48B1BE33.3060505@vieonet.com> In-Reply-To: <48B1BE33.3060505@vieonet.com> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms020109010001000700000209" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/320 X-Sequence-Number: 31201 This is a cryptographically signed message in MIME format. --------------ms020109010001000700000209 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi, dforum wrote: > Hello every body, > > I just discover a big not only big huge difference between NOW() and > CURRENT_DATE. > > Did you already know about it and do you know why ? > > DELETE FROM blacklist where bl_date < (NOW() - interval '2 DAY'); > on 6 000 000 of records > 699 ms > > DELETE FROM blacklist where bl_date < (CURRENT_DATE - interval '2 DAY'); > on 6 000 000 of records Try that with a timestamp - column and use now() and current_timestamp with a long running query and then compare min(column) max(column) in both cases :-) Regards Tino --------------ms020109010001000700000209 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJBzCC At4wggJHoAMCAQICEFhzOX0yh1CxCcTpCoXqqXkwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UE BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDQzMDE5MzY1NFoX DTA5MDQzMDE5MzY1NFowRDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEhMB8G CSqGSIb3DQEJARYSdGlub0B3aWxkZW5oYWluLmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8A MIIBCgKCAQEAwdJKlg6wlxFdjMOMON992A1RRg7jfZJWPuHXAb0VOAM4htilnwfJVdk9ARnY Jbp6uDbR7Npm3ZqrqfRlI2uPXVVj00L8JHMQmeS36ICknk7aG93yTBYWBf1T2EadP2KFszSM EmfjxV7vc55BgP1Pj9eB0ceJOT8dOWl5c342giavCWOg0xDQAKUd+BpEe3r/TnLuCUo0MIQF DAO8nw8NyKJG82u0Y8aHW5wpLS0S0E+GeVd5RP4cB1GDCiH8Bi7MvOSsFBv7tSYIn/3fJH+Q 979UGd1nhO4H+sK43mjt+gXpR7+5A3ZGy+O/5gsArCTMwGZmLZ4hd3VhPCT7TRtLmQIDAQAB oy8wLTAdBgNVHREEFjAUgRJ0aW5vQHdpbGRlbmhhaW4uZGUwDAYDVR0TAQH/BAIwADANBgkq hkiG9w0BAQUFAAOBgQA3ROUGts7nkRx1uE+rbeuhfckv9bLIL6lz19tRwTeTOYanXrqDzwhn UUMyd7oDFUIZe/lxtLshkUD4p/omXtIzCCx6M5yIWlYMzKTeB4qQpQ14huovXzXQZbWiTOwA 3+ZU+rVC7CX47dEEKuKHwAvpurNUGikHlGuYkMSMCly61zCCAt4wggJHoAMCAQICEFhzOX0y h1CxCcTpCoXqqXkwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRo YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG cmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDQzMDE5MzY1NFoXDTA5MDQzMDE5MzY1NFowRDEf MB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEhMB8GCSqGSIb3DQEJARYSdGlub0B3 aWxkZW5oYWluLmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAwdJKlg6wlxFd jMOMON992A1RRg7jfZJWPuHXAb0VOAM4htilnwfJVdk9ARnYJbp6uDbR7Npm3ZqrqfRlI2uP XVVj00L8JHMQmeS36ICknk7aG93yTBYWBf1T2EadP2KFszSMEmfjxV7vc55BgP1Pj9eB0ceJ OT8dOWl5c342giavCWOg0xDQAKUd+BpEe3r/TnLuCUo0MIQFDAO8nw8NyKJG82u0Y8aHW5wp LS0S0E+GeVd5RP4cB1GDCiH8Bi7MvOSsFBv7tSYIn/3fJH+Q979UGd1nhO4H+sK43mjt+gXp R7+5A3ZGy+O/5gsArCTMwGZmLZ4hd3VhPCT7TRtLmQIDAQABoy8wLTAdBgNVHREEFjAUgRJ0 aW5vQHdpbGRlbmhhaW4uZGUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQA3ROUG ts7nkRx1uE+rbeuhfckv9bLIL6lz19tRwTeTOYanXrqDzwhnUUMyd7oDFUIZe/lxtLshkUD4 p/omXtIzCCx6M5yIWlYMzKTeB4qQpQ14huovXzXQZbWiTOwA3+ZU+rVC7CX47dEEKuKHwAvp urNUGikHlGuYkMSMCly61zCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJ BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEa MBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2Vy dmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTEr MCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcw MDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUg Q29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065ypla HmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FW y688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEE QB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2 oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3Js MAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0x MzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYf qi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9l X5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggNkMIIDYAIBATB2 MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQu MSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQWHM5fTKH ULEJxOkKheqpeTAJBgUrDgMCGgUAoIIBwzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJBTEPFw0wODA4MjUwNjAxNDdaMCMGCSqGSIb3DQEJBDEWBBSRYeMIfAr6qEnG fSdsaVo0dteknjBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIA gDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDCBhQYJKwYBBAGCNxAE MXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEFhz OX0yh1CxCcTpCoXqqXkwgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMG A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEFhzOX0yh1CxCcTpCoXqqXkwDQYJKoZIhvcN AQEBBQAEggEAP2X23HwP3PxSvZYACdYChA/kwFRPIrCaHYiw6ousMDs9NfABEWl8wZELV2eQ 10i66QppU0nw85OiWLfUGCtIXiWKoyuGgbXwQMmX1uecStvf8IM07LoWupdivwo2H7lBTZyx eSMS/oNbMvKNnUpEfItJpDXmjxTgQQT+0AjX11PaK1ph23e9hfTrZsxY6VU8ksRIJIofHOd0 wZ6ld9qCWed8TiURSM93Eb4P/FWLlqANvm5h5QNfp7TcEd1K39nldI1xHXF+v92HZ9dKu0l4 Yb8znd1K68tdsENQwz2ejtFJBxN6ZFjbhD7ERhSVTxI9B6a4sEmSqJp7zbHxju1kxAAAAAAA AA== --------------ms020109010001000700000209--