From: ow <oneway_111@yahoo.com>
To: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg 7.4.rc1, Range query performance
Date: Mon, 10 Nov 2003 16:41:39 -0800 (PST)
Message-ID: <20031111004139.47333.qmail@web21407.mail.yahoo.com> (raw)
In-Reply-To: <20031108183630.I51201@megazone.bigpanda.com>
--- Stephan Szabo <sszabo@megazone.bigpanda.com> wrote:
> I'm not sure that AK_abc is the best index for check a range on a and
> single values on b and c. I'd think that something like an index
> on (b,c,a) would probably be better for this purpose (without doing any
> testing ;) ).
That would not work for us since most of the time users are working with most
recent data, hence column "a" is the first in the index.
Thanks
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oneway_111@yahoo.com, sszabo@megazone.bigpanda.com
Subject: Re: pg 7.4.rc1, Range query performance
In-Reply-To: <20031111004139.47333.qmail@web21407.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox