Indexing datetime

From: Sergei Barbarash <sgt(at)dot(dot)ru>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Indexing datetime
Date: 1998-08-26 06:51:50
Message-ID: 199808260651.KAA21997@zaraza.dot.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1998-08-26 08:48:20 Re: [SQL] copying rows
Previous Message Jose David Martinez Cuevas 1998-08-25 23:52:48 Once again... triggers