pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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