Postgres Pro
Downloads
Home   >   mailing lists

Re: slowness when subselect uses DISTINCT - Mailing list pgsql-sql

From Stuart McGraw
Subject Re: slowness when subselect uses DISTINCT
Date
Msg-id AKEFJAHAPDBEDKIICNJKCEOKCCAA.smcg2297@frii.com
Whole thread Raw
In response to Re: slowness when subselect uses DISTINCT  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
Responses Re: slowness when subselect uses DISTINCT  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
List pgsql-sql
Tree view 
Phillip Smith wrote:
> May I suggest you post an EXPLAIN ANALYZE to the group for the query you're
> having problems with...?

I will do that but it has happened to me enough that it seems to be
a general pattern, not something specific to one of my queries,
so I thought some communal knowledge may exist.  But apparently
not.

pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: We all are looped on Internet: request + transport = invariant
Next
From: "Markus Holzer"
Date:
Subject: Doing a conditional insert/update