Re: views much slower in 9.3 than 8.4 - Mailing list pgsql-performance

From Tom Lane
Subject Re: views much slower in 9.3 than 8.4
Date
Msg-id 13022.1426806262@sss.pgh.pa.us
Whole thread Raw
In response to Re: views much slower in 9.3 than 8.4  ("Carson, Leonard" <lcarson@sdsc.edu>)
Responses Re: views much slower in 9.3 than 8.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
"Carson, Leonard" <lcarson@sdsc.edu> writes:
> Here are the 3 views and some timing notes:
> http://pgsql.privatepaste.com/decae31693#

That doesn't really leave us any wiser than before, unfortunately.

It's clear that the root of the problem is the drastic underestimation of
the size of the rq/a join, but it's not clear why that's happening, nor
why 8.4 would not have fallen into the same trap.

Would it be possible to provide the data in the join columns involved in
that part of the query?  To wit
requests.account_id
requests.start_date
allocations.account_id
allocations.initial_start_date
allocations.resource_id

            regards, tom lane


pgsql-performance by date:

Previous
From: Joao Junior
Date:
Subject: Re: Very slow checkpoints
Next
From: Vladimir Borodin
Date:
Subject: Re: [GENERAL] [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary