[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
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
wness when subselect uses DISTINCT
I have several times now run into what seems
like similar performance problems with some
of my postgresql queries.
I have a view that runs reasonably quicky.
I use this view in a subselect in another
query and that query too runs reasonably
quicky.
The view re
I have several times now run into what seems
like similar performance problems with some
of my postgresql queries.
I have a view that runs reasonably quicky.
I use this view in a subselect in another
query and that query too runs reasonably
quicky.
The view returns some unwanted duplicate
row
