Re: Premature view materialization in 8.2?

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

To: "Jonathan Ellis" <jonathan@xxxxxxxxxxxxxx>
Subject: Re: Premature view materialization in 8.2?
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Fri, 06 Apr 2007 01:43:16 -0400
Cc: pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to "Jonathan Ellis" <jonathan@xxxxxxxxxxxxxx> message dated "Thu, 05 Apr 2007 12:46:08 -0600"
In-reply-to: <e06563880704051146r357cb15by7e498c6d796b093a@xxxxxxxxxxxxxx>
References: <e06563880704051146r357cb15by7e498c6d796b093a@xxxxxxxxxxxxxx>

"Jonathan Ellis" <jonathan@xxxxxxxxxxxxxx> writes:
> I have a query hitting a view that takes 0.15s on 8.1 but 6s on 8.2.3:
> ...
> Is this a regression, or a "feature" of 8.2?

Hard to say without EXPLAIN ANALYZE output to compare.

			regards, tom lane

Follow-Ups:
- Re: Premature view materialization in 8.2?
  - From: Jonathan Ellis

References:
- Premature view materialization in 8.2?
  - From: Jonathan Ellis

Prev by Date: Re: SCSI vs SATA
Next by Date: Re: SCSI vs SATA
Previous by thread: Premature view materialization in 8.2?
Next by thread: Re: Premature view materialization in 8.2?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux