Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #7598: Loss of view performance after dump/restore of the view definition - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7598: Loss of view performance after dump/restore of the view definition
Date
Msg-id 10398.1350315840@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #7598: Loss of view performance after dump/restore of the view definition  (Vaclav Juza <vaclav.juza@xitee.com>)
Responses Re: BUG #7598: Loss of view performance after dump/restore of the view definition  (Vaclav Juza <vaclav.juza@xitee.com>)
List pgsql-bugs
Tree view 
Vaclav Juza <vaclav.juza@xitee.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

pgsql-bugs by date:

Previous
From: seancompusult
Date:
Subject: Re: BUG #7577: JDBC Driver - Compiled with Java 7
Next
From: webmaster@dhs-club.com
Date:
Subject: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them