Re: View performance degraded between 8.1 and 8.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Roghelia <mroghelia(at)topsailtech(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: View performance degraded between 8.1 and 8.3
Date: 2009-02-11 00:37:16
Message-ID: 27426.1234312636@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mark Roghelia <mroghelia(at)topsailtech(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2009-02-11 10:58:00 please help with the explain analyze plan
Previous Message Mark Roghelia 2009-02-10 22:20:36 View performance degraded between 8.1 and 8.3