Indexing datetime - Mailing list pgsql-sql

From Sergei Barbarash
Subject Indexing datetime
Date
Msg-id 199808260651.KAA21997@zaraza.dot.ru
Whole thread Raw
List 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



pgsql-sql by date:

Previous
From: Jose David Martinez Cuevas
Date:
Subject: Once again... triggers
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] copying rows