Re: Premature view materialization in 8.2?

From: Tom Lane
Subject: Re: Premature view materialization in 8.2?
Date: ,
Msg-id: 28349.1175838196@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Premature view materialization in 8.2?  ("Jonathan Ellis")
Responses: Re: Premature view materialization in 8.2?  ("Jonathan Ellis")
List: pgsql-performance

Tree view

Premature view materialization in 8.2?  ("Jonathan Ellis", )
 Re: Premature view materialization in 8.2?  (Tom Lane, )
  Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
   Re: Premature view materialization in 8.2?  (Tom Lane, )
    Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
     Re: Premature view materialization in 8.2?  (Tom Lane, )
      Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
       Re: Premature view materialization in 8.2?  (Tom Lane, )
        Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
         Re: Premature view materialization in 8.2?  (Tom Lane, )
          Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )

"Jonathan Ellis" <> 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


pgsql-performance by date:

From: Michael Stone
Date:
Subject: Re: SCSI vs SATA
From: Michael Stone
Date:
Subject: Re: SCSI vs SATA