Re: slow to run query 5000 times

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 qu

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 app

Re: slow to run query 5000 times

Hi, 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. But here, you could just send the queries and \d for the tables. On Sat, Feb 09, 2019 at 01:45:50PM -0300, Evandro Abreu wrote: > I have a report that take