From: Robert Haas <robertmhaas@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Aaron Guyon <battlemage@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres 8.3, four times slower queries?
Date: Thu, 5 Mar 2009 11:56:08 -0500
Message-ID: <603c8f070903050856y37d9825bga53fcc2017143163@mail.gmail.com> (raw)
In-Reply-To: <49AF9952.EE98.0025.0@wicourts.gov>
References: <f0afbb9b0903021618w616f1158t84dbf119f0b72c70@mail.gmail.com>
<2870.1236050632@sss.pgh.pa.us>
<f0afbb9b0903030931g7b219137n2954cf058d523e52@mail.gmail.com>
<17797.1236119652@sss.pgh.pa.us>
<f0afbb9b0903041520u25aae965y6abc15d39644eb5b@mail.gmail.com>
<603c8f070903050521q64ea85efnff129b1cb6d5c502@mail.gmail.com>
<49AF9952.EE98.0025.0@wicourts.gov>
On Thu, Mar 5, 2009 at 10:20 AM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
>>>> Robert Haas <robertmhaas@gmail.com> wrote:
>> Well, it looks like the problem is that 8.3 is not using the index
>> idx_bundle_content_bundle_id. But I don't know why that should be
>> happening, unless there's a problem with that index.
>
> I didn't see that index defined. In fact, in the query shown, t8 is
> the payment_amount table, but in plan, I don't see any references to
> that table, and t8 is a table called bundle_content which is not
> included.
Good point. Now that you mention it, I notice that many of the tables
and columns seem to have been renamed. It's pretty hard to make
anything intelligible out of a schema that doesn't resemble the plan.
...Robert
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: robertmhaas@gmail.com, Kevin.Grittner@wicourts.gov, battlemage@gmail.com
Subject: Re: Postgres 8.3, four times slower queries?
In-Reply-To: <603c8f070903050856y37d9825bga53fcc2017143163@mail.gmail.com>
References: <f0afbb9b0903021618w616f1158t84dbf119f0b72c70@mail.gmail.com> <2870.1236050632@sss.pgh.pa.us> <f0afbb9b0903030931g7b219137n2954cf058d523e52@mail.gmail.com> <17797.1236119652@sss.pgh.pa.us> <f0afbb9b0903041520u25aae965y6abc15d39644eb5b@mail.gmail.com> <603c8f070903050521q64ea85efnff129b1cb6d5c502@mail.gmail.com> <49AF9952.EE98.0025.0@wicourts.gov> <603c8f070903050856y37d9825bga53fcc2017143163@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox