Re: slow to run query 5000 times

From: Ricardo Martin Gomez <rimartingomez(at)hotmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Andres Freund <andres(at)anarazel(dot)de>
Cc: Evandro Abreu <evandro(dot)abreu(at)gmail(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: slow to run query 5000 times
Date: 2019-02-10 00:23:59
Message-ID: SC1P15201MB2304B73CE1449EC695317FB1A36B0@SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,
Do you have an index in the date field?

Obtener Outlook para Android<https://aka.ms/ghei36>

________________________________
From: Andres Freund <andres(at)anarazel(dot)de>
Sent: Saturday, February 9, 2019 5:23:14 PM
To: Justin Pryzby
Cc: Evandro Abreu; pgsql-performance(at)lists(dot)postgresql(dot)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 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2019-02-10 06:26:14 Re: dsa_allocate() faliure
Previous Message Thomas Munro 2019-02-09 21:06:30 Re: dsa_allocate() faliure