Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 04 Jan 2007 20:12:49 -0500
- Message-id: <7598(dot)1167959569(at)sss(dot)pgh(dot)pa(dot)us>
"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
- Follow-Ups:
- Re: Slow Query on Postgres 8.2
- From: Dave Dutcher
- Re: Slow Query on Postgres 8.2
- References:
- Slow Query on Postgres 8.2
- From: Dave Dutcher
- Slow Query on Postgres 8.2
- Prev by Date: Slow Query on Postgres 8.2
- Next by Date: Re: Slow Query on Postgres 8.2
- Previous by thread: Slow Query on Postgres 8.2
- Next by thread: Re: Slow Query on Postgres 8.2
- Indexes: