| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Claude Speed <gta3user(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: new BUG: "postgresql 9.2.3: very long query time" |
| Date: | 2013-02-21 17:25:31 |
| Message-ID: | CAMkU=1wtFVHd9JQidMjANWkGQ3crrmWhgMOJ6OqD+80Dw=rhZA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Feb 20, 2013 at 5:42 AM, Claude Speed <gta3user(at)gmail(dot)com> wrote:
> Hi all,
>
> Postgresql 9.2.3 is processing my query is much longer than Postgresql
> 9.1.8:
> Postgresql 9.1.8 - 2292 ms
> Postgresql 9.2.3 - 163336 ms
>
> I provided my query in attach and the database dump too,
> this bug is reproducible.
>
> Operating system: Gentoo x86_64 Linux 2.6.36
The slowness was introduced with this:
commit e2fa76d80ba571d4de8992de6386536867250474
Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Date: Fri Jan 27 19:26:38 2012 -0500
Use parameterized paths to generate inner indexscans more flexibly.
Do you know of simpler queries that also exhibits this behavior? It
would certainly make analysis of the issue easier.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | amutu | 2013-02-22 01:50:32 | BUG #7899: allow key word as alias in subquery but Can't reference it in outer query |
| Previous Message | Heikki Linnakangas | 2013-02-21 12:04:09 | Re: BUG #7883: "PANIC: WAL contains references to invalid pages" on replica recovery |