Postgres Pro
Downloads
Home   >   mailing lists

Re: View performance degraded between 8.1 and 8.3 - Mailing list pgsql-performance

From Tom Lane
Subject Re: View performance degraded between 8.1 and 8.3
Date
Msg-id 27426.1234312636@sss.pgh.pa.us
Whole thread Raw
In response to View performance degraded between 8.1 and 8.3  (Mark Roghelia <mroghelia@topsailtech.com>)
List pgsql-performance
Tree view 
Mark Roghelia <mroghelia@topsailtech.com> writes:
> Unfortunately, I've recently upgraded to 8.3 and found that selecting
> a single column from this view has now become as slow as selecting all
> of them.

Without specifics there's really no way to answer this.

            regards, tom lane

pgsql-performance by date:

Previous
From: Mark Roghelia
Date:
Subject: View performance degraded between 8.1 and 8.3
Next
From: Rajesh Kumar Mallah
Date:
Subject: please help with the explain analyze plan