Received: from zaraza.dot.ru ([195.151.91.184]) by hub.org (8.8.8/8.7.5) with ESMTP id CAA28742 for ; Wed, 26 Aug 1998 02:50:50 -0400 (EDT) Received: from zaraza (localhost.ogo.ru [127.0.0.1]) by zaraza.dot.ru (8.8.8/8.8.8) with ESMTP id KAA21997 for ; Wed, 26 Aug 1998 10:51:51 +0400 (MSD) (envelope-from sgt@zaraza.dot.ru) Message-Id: <199808260651.KAA21997@zaraza.dot.ru> X-Mailer: exmh version 1.6.9 8/22/96 X-face: =^q.\_{=6A5?NeV4x^y8^c9fYLov(VQ=V7Q"p; G|Tx65CH8)=v%1M"/!seMC0oD:)wKSuhC Y&z[m7$XMmM}Q-mHsqALu'FSk7; ytq).]{}|X)Jfe-<7; %xFA4m%OV3,!XF5K!O:B}2Bd0%4y.~~`W !\*/Tis2n"ETu[yflT)l{xWqLf.)7j*0B4/\E9$qp X-url: http://zaraza.rinet.ru/ To: pgsql-sql@postgreSQL.org Subject: Indexing datetime Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Wed, 26 Aug 1998 10:51:50 +0400 From: Sergei Barbarash Hello, I have a table for web server logs, which contains a datetime column. Most of my queries depend on date/time clauses (retrieving periods of time). It works terribly slow. Can I optimize it somehow? How should I create an index? What operators should I use in the clauses? Thanks in advance, -- Sergei