Re: a JOIN to a VIEW seems slow

On Monday, October 2, 2017 2:32:34 AM EDT Frank Millman wrote:
> From: Frank Millman
> Sent: Friday, September 22, 2017 7:34 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: a JOIN to a VIEW seems slow
>
> On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote:
> > On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote:
> > > Something is not adding up here. Can you EXPLAIN ANALYZE the 26 minute
> > > query?
> > >
> > > Here it is -
> >
> > https://explain.depesz.com/s/cwm
>
> Just checking – is this under investigation, or is this thread considered
> closed?

That's not how it works. This is a community list; if somebody finds your
problem interesting you will get feedback, but there is no guarantee you will
get any.

One suggestion is to provide as much details as possible (server version info,
table definitions, full SQL statements, explain results, etc). I haven't looked
back in the thread to see if yu actually did this, but that's often the reason
for no/little feedback.

Another thing is to make life easier on the other list members by adhering to
community conventions, i.e. text-only (no HTML) emails, reply trimming, and
bottom posting.