Search Postgresql Archives

Re: 8.1 vs 8.2.1 view optimization

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Nathan Bell <nathanb@xxxxxxxxxx>
Subject: Re: 8.1 vs 8.2.1 view optimization
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 16 Jan 2007 17:03:12 -0500
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Tom Lane <tgl@xxxxxxxxxxxxx> message dated "Tue, 16 Jan 2007 17:01:08 -0500"
In-reply-to: <26760.1168984868@xxxxxxxxxxxxx>
References: <45AD42A5.8000705@xxxxxxxxxx> <26458.1168983637@xxxxxxxxxxxxx> <45AD49BC.3030208@xxxxxxxxxx> <26760.1168984868@xxxxxxxxxxxxx>

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

Sheesh ... s/nonvolatile/volatile/ of course ... this thread seems
afflicted with getting-it-backward disease :-(

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- 8.1 vs 8.2.1 view optimization
  - From: Nathan Bell
- Re: 8.1 vs 8.2.1 view optimization
  - From: Tom Lane
- Re: 8.1 vs 8.2.1 view optimization
  - From: Nathan Bell
- Re: 8.1 vs 8.2.1 view optimization
  - From: Tom Lane

Prev by Date: Re: 8.1 vs 8.2.1 view optimization
Next by Date: Re: 8.1 vs 8.2.1 view optimization
Previous by thread: Re: 8.1 vs 8.2.1 view optimization
Next by thread: Re: 8.1 vs 8.2.1 view optimization
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux