Re: slowness when subselect uses DISTINCT

From: "Stuart McGraw" <smcg2297(at)frii(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: slowness when subselect uses DISTINCT
Date: 2007-04-19 14:20:28
Message-ID: AKEFJAHAPDBEDKIICNJKCEOKCCAA.smcg2297@frii.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Holzer 2007-04-19 18:27:30 Doing a conditional insert/update
Previous Message Andrew Sullivan 2007-04-19 13:48:08 Re: We all are looped on Internet: request + transport = invariant