From: Hiroshi Inoue <Inoue@tpf.co.jp>
To: Daniel Kalchev <daniel@digsys.bg>
Cc: pgsql-hackers@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: again on index usage
Date: Tue, 15 Jan 2002 23:10:55 +0900
Message-ID: <EKEJJICOHDIEMGPNIFIJCELDGHAA.Inoue@tpf.co.jp> (raw)
In-Reply-To: <200201100939.LAA28676@dcave.digsys.bg>
> -----Original Message-----
> From: Daniel Kalchev
>
> I tried this:
>
> db=# select * into iplog_test from iplog_gate200112;
> SELECT
> db=# create index iplog_test_ipaddr_idx on iplog_test(ipaddr);
> CREATE
> db=# cluster iplog_test_ipaddr_idx on iplog_test;
> CLUSTER
> db=# create index iplog_test_ipdate_idx on iplog_test(ipdate);
> CREATE
> db=# explain
> db-# SELECT sum(input), sum(output) FROM iplog_test
> db-# WHERE
> db-# '2001-12-01 00:00:00+02' <= ipdate AND ipdate < '2001-12-02
> 00:00:00+02'
Is there only one ipdate value which satisfies the above where clause ?
regards,
Hiroshi Inoue
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-hackers@postgresql.org
Cc: Inoue@tpf.co.jp, daniel@digsys.bg, tgl@sss.pgh.pa.us
Subject: Re: again on index usage
In-Reply-To: <EKEJJICOHDIEMGPNIFIJCELDGHAA.Inoue@tpf.co.jp>
* 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