agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Jayadevan <Jayadevan.Maymala@ibsplc.com>
To: pgsql-performance@postgresql.org
Subject: Re: Query performance issue
Date: Mon, 5 Sep 2011 20:30:12 -0700 (PDT)
Message-ID: <1315279812138-4773061.post@n5.nabble.com> (raw)
In-Reply-To: <OF054D4A85.793AE12E-ON65257902.0012C0A0-65257902.0017BA23@ibsplc.com>
References: <OF6B813C80.12B50253-ON652578FD.00310FC3-652578FD.00317C74@ibsplc.com>
<4E6345520200002500040BD6@gw.wicourts.gov>
<12017.1315149499@sss.pgh.pa.us>
<1315159591749-4768047.post@n5.nabble.com>
<0b5904ed666013250682b895d8266324.squirrel@sq.gransy.com>
<OF054D4A85.793AE12E-ON65257902.0012C0A0-65257902.0017BA23@ibsplc.com>
Based on my initial hunch that something resulting from all the ALTERS was
making PostgreSQL planner end up with bad plans, I tried a pg_dump and
pg_restore. Now the 'bad' query comes back in 70 seconds (compared to 20
minutes earlier) and the rewritten query still comes back in 2 seconds. So
we will stick with the re-written query.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Query-performance-issue-tp4753453p4773061.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
view thread (57+ messages) latest in thread
Message-ID: <1315279812138-4773061.post@n5.nabble.com>
Permalink: ../1315279812138-4773061.post@n5.nabble.com/
Also on: postgresql.org/message-id/1315279812138-4773061.post@n5.nabble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Jayadevan.Maymala@ibsplc.com
Subject: Re: Query performance issue
In-Reply-To: <1315279812138-4773061.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox