Re: Slow Query on Postgres 8.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dave Dutcher" <dave(at)tridecap(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow Query on Postgres 8.2
Date: 2007-01-05 01:12:49
Message-ID: 7598.1167959569@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Dave Dutcher" <dave(at)tridecap(dot)com> writes:
> I am looking at upgrading from 8.1.2 to 8.2.0, and I've found a query which
> runs a lot slower.

Um ... what indexes has this table got exactly? It's very unclear what
alternatives the planner is being faced with.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Rich 2007-01-05 01:19:25 Re: Slow Query on Postgres 8.2
Previous Message Dave Dutcher 2007-01-04 23:31:43 Slow Query on Postgres 8.2