Re: Index usage vs large repetitions of key

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: "Francisco Reyes" <lists(at)natserv(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Index usage vs large repetitions of key
Date: 2002-05-04 20:35:34
Message-ID: 20020504163534.1dab24c8.nconway@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 4 May 2002 16:25:47 -0400 (EDT)
"Francisco Reyes" <lists(at)natserv(dot)com> wrote:
> I have numerous queries I do against this table that only need to acces
> one or two years.

Can you post some of the queries that are problematic, as well as the
output of EXPLAIN ANALYZE for them?

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Snyder 2002-05-04 21:40:07 Re: Using views and MS access via odbc
Previous Message Francisco Reyes 2002-05-04 20:25:47 Index usage vs large repetitions of key