| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | lcarson(at)sdsc(dot)edu |
| Cc: | pgsql-bugs(at)postgresql(dot)org, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Subject: | Re: BUG #12859: views much slower in 9.4.1 than 8.4.7 |
| Date: | 2015-03-12 23:16:18 |
| Message-ID: | 3304.1426202178@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> writes:
> On 12.3.2015 21:59, lcarson(at)sdsc(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2015-03-12 23:32:28 | Re: pg_upgrade failure on Windows Server |
| Previous Message | Tomas Vondra | 2015-03-12 23:10:46 | Re: BUG #12859: views much slower in 9.4.1 than 8.4.7 |