Re: BUG #7598: Loss of view performance after dump/restore of the view definition

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vaclav Juza <vaclav(dot)juza(at)xitee(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7598: Loss of view performance after dump/restore of the view definition
Date: 2012-10-15 15:44:00
Message-ID: 10398.1350315840@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Vaclav Juza <vaclav(dot)juza(at)xitee(dot)com> writes:
> I have modified the test case (it is more similar to the real-word
> query), so that now it is slower on 9.2.1 than on 9.1.4 (the version
> with the explicit cast):

FWIW, testing this on HEAD (with the patch I committed last week),
I get a plan that's about 10% faster than 9.1; or if I disable
index-only scans for a more level playing field, it's just about
equivalent to 9.1.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message webmaster 2012-10-15 16:01:21 BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them
Previous Message seancompusult 2012-10-15 15:10:07 Re: BUG #7577: JDBC Driver - Compiled with Java 7