Re: max time in a table query takes ages

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Grzegorz Ja=?ISO-8859-2?B?tg==?=kiewicz <gryzman(at)gmail(dot)com>
Cc: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: max time in a table query takes ages
Date: 2008-10-24 17:19:04
Message-ID: C5275FA8.A6BE0%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Can postgres use combined indicies for queries that would only require part of
> it ?

Even if not, if there is at least one index that reduces the potential
matches to a small set, then scanning those rows against the other criteria
won't take so long. (Assuming good stats and PG choosing a good plan.)

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jack Orenstein 2008-10-24 18:21:50 Re: Postgres optimizer choosing wrong index
Previous Message Thom Brown 2008-10-24 16:31:01 Re: Escape wildcard problems.