Postgres Pro
Downloads
Home   >   mailing lists

Re: Index usage vs large repetitions of key - Mailing list pgsql-general

From Neil Conway
Subject Re: Index usage vs large repetitions of key
Date
Msg-id 20020504163534.1dab24c8.nconway@klamath.dyndns.org
Whole thread Raw
In response to Index usage vs large repetitions of key  (Francisco Reyes <lists@natserv.com>)
Responses Re: Index usage vs large repetitions of key
List pgsql-general
Tree view 
On Sat, 4 May 2002 16:25:47 -0400 (EDT)
"Francisco Reyes" <lists@natserv.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@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Index usage vs large repetitions of key
Next
From: Ron Snyder
Date:
Subject: Re: Using views and MS access via odbc