Received: from p2272.nsk.ne.jp (p2272.nsk.ne.jp [210.145.18.145]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0FEBiV78393 for ; Tue, 15 Jan 2002 09:11:44 -0500 (EST) (envelope-from Inoue@tpf.co.jp) Received: from mcadnote1 (ppm104.noc.fukui.nsk.ne.jp [61.198.95.4]) by p2272.nsk.ne.jp (8.9.3/3.7W-20000722) with SMTP id XAA05900; Tue, 15 Jan 2002 23:10:59 +0900 (JST) From: "Hiroshi Inoue" To: "Daniel Kalchev" Cc: , "Tom Lane" Subject: Re: again on index usage Date: Tue, 15 Jan 2002 23:10:55 +0900 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <200201100939.LAA28676@dcave.digsys.bg> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-Archive-Number: 200201/618 X-Sequence-Number: 17636 > -----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