Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Improving Query
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Richard Huxton <dev(at)archonet(dot)com>
- Cc: Ketema <ketema(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: Improving Query
- Date: Tue, 30 Oct 2007 11:39:12 -0400
Richard Huxton <dev(at)archonet(dot)com> writes: > Ketema wrote: >> 5)Upgrade version of pg..currently is running 8.1.4 > Well every version gets better at planning, so it can't hurt. +1 ... there are at least two things about this query that 8.2 could be expected to be a great deal smarter about: * mixed outer and inner joins * something = ANY(array) regards, tom lane
- Follow-Ups:
- Re: Improving Query
- From: Ketema Harris
- Re: Improving Query
- References:
- Improving Query
- From: Ketema
- Re: Improving Query
- From: Richard Huxton
- Improving Query
- Prev by Date: Re: Optimizing PostgreSQL for Windows
- Next by Date: Re: Optimizing PostgreSQL for Windows
- Previous by thread: Re: Improving Query
- Next by thread: Re: Improving Query
- Indexes: