Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> On 12.3.2015 21:59, lcarson@sdsc.edu wrote:
>> We have views that are running anywhere from 20x slower to failing to
>> complete in 9.4.1 whereas in 8.4.7 they produced results in seconds
>> or tensof seconds on the same platform.
> You have not provided explain plans from 8.4, and I'd bet it was using a
> different plan on that version.
We'd really need far more information than that to investigate this.
Please see
https://wiki.postgresql.org/wiki/Slow_Query_Questions
Also, as suggested on that page, pgsql-performance is likely a better
venue for this discussion than pgsql-bugs.
regards, tom lane