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@xxxxxxxxxxxxxx > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
