Received: from zaraza.dot.ru ([195.151.91.184]) by hub.org (8.8.8/8.7.5) with ESMTP id DAA11877 for ; Wed, 2 Sep 1998 03:06:29 -0400 (EDT) Received: from zaraza (localhost [127.0.0.1]) by zaraza.dot.ru (8.8.8/8.8.8) with ESMTP id LAA22700 for ; Wed, 2 Sep 1998 11:07:43 +0400 (MSD) (envelope-from sgt@zaraza.dot.ru) Message-Id: <199809020707.LAA22700@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, 02 Sep 1998 11:07:42 +0400 From: Sergei Barbarash I have a very large and fast-growing table with a datetime field. Most of my queries are based on date comparison as well. Like: select * from table where time > 'Aug 1 0:0:0 1998' and time < 'Sep 1 0:0:0 1998'; How can I index the table to optimize my queries? Or maybe datetime is a bad choice for this? -- Sergei