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

Re: Slow views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Newall <davidn-postgres(at)rebel(dot)net(dot)au>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,PostgreSQL bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Slow views
Date: 2004-07-17 05:00:55
Message-ID: 1767.1090040455@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
David Newall <davidn-postgres(at)rebel(dot)net(dot)au> writes:
> It's clearly an optimisation issue:

No, it's an outer-join-semantics issue.

> select * from a join b optimises differently to select * from a join
> (select * from b) as b

The above claim is provably false.  Now, if you throw in some more
tables and sprinkle in a LEFT JOIN instead of just JOIN here and there,
you can get different plans --- but the semantics are not necessarily
the same, either.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-07-17 05:08:07
Subject: Re: Cannot recreate DB scheme using pg_dump
Previous:From: David NewallDate: 2004-07-17 04:48:47
Subject: Re: Slow views

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