Re: [PERFORM] Please help with a slow query: there are millions of records, what can we do?

2017-03-08 Thread Jeff Janes
On Tue, Mar 7, 2017 at 6:26 PM, Pat Maddox wrote: > Hi there, > > I’ve been asked to help with a project dealing with slow queries. I’m > brand new to the project, so I have very little context. I’ve gathered as > much information as I can. > > I’ve put the schema, query, and explain info in gist

Re: [PERFORM] Please help with a slow query: there are millions of records, what can we do?

2017-03-08 Thread Albe Laurenz
Pat Maddox wrote: > I’ve been asked to help with a project dealing with slow queries. I’m brand > new to the project, so I > have very little context. I’ve gathered as much information as I can. > > I’ve put the schema, query, and explain info in gists to maintain their > formatting. > > We are