Re: Unused table of view - Mailing list pgsql-performance

From Tom Lane
Subject Re: Unused table of view
Date
Msg-id 24845.1086456990@sss.pgh.pa.us
Whole thread Raw
In response to Unused table of view  (Laurent Martelli <laurent@aopsys.com>)
Responses Re: Unused table of view  (Laurent Martelli <laurent@aopsys.com>)
List pgsql-performance
Laurent Martelli <laurent@aopsys.com> writes:
> The pictures table is scanned, but it's not needed.

Yes it is.  For example, if pictures is empty then the view yields
zero rows.  Omitting the join to pictures could give a different result.

            regards, tom lane

pgsql-performance by date:

Previous
From: Laurent Martelli
Date:
Subject: Unused table of view
Next
From: Laurent Martelli
Date:
Subject: Re: Unused table of view