Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group