Received: from www.dot.ru (www.DOT.ru [194.84.34.5]) by hub.org (8.8.8/8.7.5) with ESMTP id LAA16294 for ; Thu, 3 Sep 1998 11:12:56 -0400 (EDT) Received: (from sgt@localhost) by www.dot.ru (8.8.8/8.8.8) id TAA03736 for pgsql-sql@postgreSQL.org; Thu, 3 Sep 1998 19:11:11 +0400 (MSD) (envelope-from sgt) Date: Thu, 3 Sep 1998 19:11:11 +0400 (MSD) From: Sergei Barbarash Message-Id: <199809031511.TAA03736@www.dot.ru> To: pgsql-sql@postgreSQL.org Subject: indexing datetime 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