new BUG: "postgresql 9.2.3: very long query time"

From: Claude Speed <gta3user(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: new BUG: "postgresql 9.2.3: very long query time"
Date: 2013-02-20 13:42:22
Message-ID: 5124D2BE.5090001@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Attachment Content-Type Size
query.sql text/plain 1.2 KB
database.dump.gz application/gzip 4.4 MB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2013-02-20 14:19:19 pg_dumpall fails if a database name contains =
Previous Message Alexander Law 2013-02-20 12:00:00 Re: BUG #7493: Postmaster messages unreadable in a Windows console