Re: [SQL] slowness when subselect uses DISTINCT

2007-04-19 Thread Phillip Smith
[SQL] slowness when subselect uses DISTINCT 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 o

Re: [SQL] slowness when subselect uses DISTINCT

2007-04-19 Thread Stuart McGraw
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 ma

Re: [SQL] slowness when subselect uses DISTINCT

2007-04-18 Thread Phillip Smith
May I suggest you post an EXPLAIN ANALYZE to the group for the query you're having problems with...? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart McGraw Sent: Thursday, 19 April 2007 04:17 To: pgsql-sql@postgresql.org Subject: [SQL] slowness whe