pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Indexing datetime
3+ messages / 2 participants
[nested] [flat]

* Indexing datetime
@ 1998-08-26 06:51  Sergei Barbarash <sgt@dot.ru>
  0 siblings, 0 replies; 3+ messages in thread

From: Sergei Barbarash @ 1998-08-26 06:51 UTC (permalink / raw)
  To: 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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* indexing datetime
@ 1998-09-02 07:07  Sergei Barbarash <sgt@dot.ru>
  0 siblings, 0 replies; 3+ messages in thread

From: Sergei Barbarash @ 1998-09-02 07:07 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* indexing datetime
@ 1998-09-03 15:11  Sergei Barbarash <sgt@www.dot.ru>
  0 siblings, 0 replies; 3+ messages in thread

From: Sergei Barbarash @ 1998-09-03 15:11 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1998-09-03 15:11 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-26 06:51 Indexing datetime Sergei Barbarash <sgt@dot.ru>
1998-09-02 07:07 indexing datetime Sergei Barbarash <sgt@dot.ru>
1998-09-03 15:11 indexing datetime Sergei Barbarash <sgt@www.dot.ru>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox