And if it helps,
see below results of my explain(analyze, buffers) where it is worse on
9.2.1 than on 9.1.4 (both on the same hardware):
Original view:
pg 9.1.4:
Nested Loop (cost=237.46..289.36 rows=1 width=254) (actual
time=3998.609..5870.697 rows=1848 loops=1)
Buffers: shared hit=1044261 re
rpose of this updated test case was mainly that you can
check which change between 9.1.4 and 9.2.1 could have caused this
performance regression and if this change can have some negative impact
(on different queries) even after applying the patch.
Thanks for the patch anyway.
Regards,
Vaclav Juza
-- pg 9.1.4: time ~= 231s
-- pg 9.2.1: time ~= 215s
=== END TEST SETUP ==
select * from testview;
-- pg 9.1.4 time~=2.6s cost=115295.20..119729.68
-- pg 9.2.1 time~=2.6s cost=137353.53..141869.38
DO language plpgsql $$
declare
begin
execute '' ||
(
s
The following bug has been logged on the website:
Bug reference: 7598
Logged by: Vaclav Juza
Email address: vaclav.j...@xitee.com
PostgreSQL version: 9.2.1
Operating system: Linux 2.6.18-128.el5 x86_64 (RHEL 5.3)
Description:
Hi,
when a view (with the below