Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gscuq-0005VG-Av for pgsql-performance@arkaria.postgresql.org; Sun, 10 Feb 2019 00:24:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gscum-0006yQ-K1 for pgsql-performance@arkaria.postgresql.org; Sun, 10 Feb 2019 00:24:08 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gscul-0006yI-MD for pgsql-performance@lists.postgresql.org; Sun, 10 Feb 2019 00:24:08 +0000 Received: from mail-oln040092011092.outbound.protection.outlook.com ([40.92.11.92] helo=NAM04-SN1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gscuh-0005jZ-5h for pgsql-performance@lists.postgresql.org; Sun, 10 Feb 2019 00:24:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=ZEeTGezD4t075fKddcrs6GGT0GE7XkS+oRxsHlaOPw0=; b=rpjcqzmVuhIL9jumYWrkPsqkRrHcuGjeSJRsYcpigB3MYs7OFK+HO3NvvtQ6OI64F1ac0Dc7Ydk8NrQIY6a16LuiDB2xcMFqCoYxp0uXLF4AuyLaP8yItjpwGLg7FbKKyi465wpOD1adKHDAl3LzEfSSbhajs2oKwAkW+X14xE/XedZAiSpd43nrHC7fU2wZXEAEfxoM5IaIzPSHCttoSdKv2/IcesCrAMVJX4psb04BF/FwNPx+FVR/YmsbVtfrEp98I15lDwtGcvHLKIQbGOz63Oclwt1cXn4g435YVMM9MRAE/oP1ixuSIoKSirA1iHJ1I0qpNRzbt/0V+aDd/Q== Received: from SN1NAM04FT006.eop-NAM04.prod.protection.outlook.com (10.152.88.59) by SN1NAM04HT048.eop-NAM04.prod.protection.outlook.com (10.152.89.42) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1580.10; Sun, 10 Feb 2019 00:23:59 +0000 Received: from SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM (10.152.88.51) by SN1NAM04FT006.mail.protection.outlook.com (10.152.88.166) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1580.10 via Frontend Transport; Sun, 10 Feb 2019 00:23:59 +0000 Received: from SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM ([fe80::1ca1:beec:530c:2a03]) by SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM ([fe80::1ca1:beec:530c:2a03%2]) with mapi id 15.20.1601.016; Sun, 10 Feb 2019 00:23:59 +0000 From: Ricardo Martin Gomez To: Justin Pryzby , Andres Freund CC: Evandro Abreu , "pgsql-performance@lists.postgresql.org" Subject: Re: slow to run query 5000 times Thread-Topic: slow to run query 5000 times Thread-Index: AQHUwJb97OSz1/s2XEOgxLgvsOAL26XXtTqAgAA0KQCAAENDqw== Date: Sun, 10 Feb 2019 00:23:59 +0000 Message-ID: References: <20190209171633.GO31721@telsasoft.com>,<20190209202314.jzk2ofojmvcnohjw@alap3.anarazel.de> In-Reply-To: <20190209202314.jzk2ofojmvcnohjw@alap3.anarazel.de> Accept-Language: es-AR, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:5ED97062458079A2F1A3E5C89FF85CB184999C1AFA71428CBE94D2C4CEF5A605;UpperCasedChecksum:B8A7ABC78A983287645E15CC63BDB03269CCBBB3710E626CE286531F8E6B256E;SizeAsReceived:7208;Count:46 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [gh8iMG19WgjCT+GtHEftZMeNxFSBK1wh] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;SN1NAM04HT048;6:p+nFGcEMNPcJKnW7/793bK0ORmzPXeNO40M72kbsHLHyZYkP4yUPkJFA4jQ03rpPFD1bG2aDf1NUPL7rQNVOfO4iMxxoXWANNGWe0EVbrShOqIb7JJDPOxa3MDqHOscTnFb8rI6dM8GhlD7z2i5pykQCHzARDoRETr90ApQA/NK1YsumfD7+SZriYVw3syUETSvrqXpvbqOQjH6ViA41S9kBGaQ5vwt28RAP+wqnRa+MVEC5M+UFvOze++irepbrf9MVcG2Fsmb1E2Wg5jetIHy6/9h8DviQPnVssGyHuiq6D9n+t/z4QDZ9/jluTIt2UnhUjPv7zn9deuH0/FDs2Q+3viXU2KsGYOLWr97jANmvnoK/W1MMvNZ4EoCMfOCdLJQCKBP+GIMZyfQ6S5JiDntUpG4In6B0jl9PNQrJhllYyNGk3WIu+Ms0LderJ6oBx+MaszzTUswuAUIGTvNdxQ==;5:t/hYJwP2Za9gg0EfZ899N9pij/osfG760uILjR0Mbj38pviqK7M4yuS1ySm/xTMAYTzxoChSWBH41c4S8LGE2VIy0ZJl7DPW3q8O2KuH8WiDUk8hnW3ZkLEL5jMmEIibNNswsTWT2GEtTj9XEtrPIWH2ItR5kW85wCU2RwQ3R6eCqFXUpS3x4+NAduknDVl7lzS5NrLNu+HrXvewFOEfUw==;7:fcsgUi6737lS5s83lewhZlbNWpDSPrpOYGyVXQBuFZLEv2nzKM81iFQ8SdEr/sAnsm6+gMu6CldrtPLKQ7uJaW84cLFLA1H0xZhZTU5fAFXbRQ/JheOwV0xqOtA3ZIienXOVmbxTFnojY0n4ehK7PA== x-incomingheadercount: 46 x-eopattributedmessage: 0 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(7020095)(201702061078)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031322404)(2017031323274)(2017031324274)(1601125500)(1603101475)(1701031045);SRVR:SN1NAM04HT048; x-ms-traffictypediagnostic: SN1NAM04HT048: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(4566010)(82015058);SRVR:SN1NAM04HT048;BCL:0;PCL:0;RULEID:;SRVR:SN1NAM04HT048; x-microsoft-antispam-message-info: qjEWlkCk0q3Mddp3YyDfUE5m1gsxOPsUq8nuWF74OZl5j9kKqS3P9eUxXSb/n34U Content-Type: multipart/alternative; boundary="_000_SC1P15201MB2304B73CE1449EC695317FB1A36B0SC1P15201MB2304_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: f12efbb0-867f-4c93-8261-502eceebfafa X-MS-Exchange-CrossTenant-Network-Message-Id: 57329ac3-cd57-4161-3dcc-08d68eee0d4f X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: f12efbb0-867f-4c93-8261-502eceebfafa X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Feb 2019 00:23:59.4930 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1NAM04HT048 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_SC1P15201MB2304B73CE1449EC695317FB1A36B0SC1P15201MB2304_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, Do you have an index in the date field? Obtener Outlook para Android ________________________________ From: Andres Freund Sent: Saturday, February 9, 2019 5:23:14 PM To: Justin Pryzby Cc: Evandro Abreu; pgsql-performance@lists.postgresql.org Subject: Re: slow to run query 5000 times Hi, On 2019-02-09 11:16:33 -0600, Justin Pryzby wrote: > Please don't send images to the list, you can send a link to one of the i= mage > host websites if you need to describe something graphical. FWIW, I don't agree with that policy. I plenty of time process email while withoug internet, so I appreciate self contained email. Greetings, Andres Freund --_000_SC1P15201MB2304B73CE1449EC695317FB1A36B0SC1P15201MB2304_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Hi,
Do you have an index in the date field?

From: Andres Freund <a= ndres@anarazel.de>
Sent: Saturday, February 9, 2019 5:23:14 PM
To: Justin Pryzby
Cc: Evandro Abreu; pgsql-performance@lists.postgresql.org
Subject: Re: slow to run query 5000 times
 
Hi,

On 2019-02-09 11:16:33 -0600, Justin Pryzby wrote:
> Please don't send images to the list, you can send a link to one of th= e image
> host websites if you need to describe something graphical.

FWIW, I don't agree with that policy. I plenty of time process email
while withoug internet, so I appreciate self contained email.

Greetings,

Andres Freund

 --_000_SC1P15201MB2304B73CE1449EC695317FB1A36B0SC1P15201MB2304_--