Re: 8.1 vs 8.2.1 view optimization - Mailing list pgsql-general

From Tom Lane
Subject Re: 8.1 vs 8.2.1 view optimization
Date
Msg-id 26760.1168984868@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.1 vs 8.2.1 view optimization  (Nathan Bell <nathanb@actarg.com>)
Responses Re: 8.1 vs 8.2.1 view optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Nathan Bell <nathanb@actarg.com> writes:
> What if the item that is taking a long time isn't a function, but rather
> a sub-select?

The point is that the view won't be flattened if there are nonvolatile
functions in its SELECT list.

            regards, tom lane

pgsql-general by date:

Previous
From: Nathan Bell
Date:
Subject: Re: 8.1 vs 8.2.1 view optimization
Next
From: Tom Lane
Date:
Subject: Re: 8.1 vs 8.2.1 view optimization