Re: Unused table of view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurent Martelli <laurent(at)aopsys(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Unused table of view
Date: 2004-06-05 17:36:30
Message-ID: 24845.1086456990@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Laurent Martelli <laurent(at)aopsys(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Carlos Eduardo Smanioto 2004-06-05 18:55:32 [OFF-TOPIC] - Known maximum size of the PostgreSQL Database
Previous Message Laurent Martelli 2004-06-05 14:37:26 Unused table of view