THAT WAS IT!!
Thank you very much.
Is there a way to change the type of "CURRENT_TIMESTAMP" to "timestamp
without time zone" so that casting isn't needed?
BTW, isn't this a bug?
-- Harmon
Stephan Szabo wrote:
On Mon, 26 Jul 2004, Harmon S. Nine wrote:
n every 15 minutes.
Good luck...
Harmon S. Nine wrote:
Hello --
To increase query (i.e. select) performance, we're trying to get
postgres to use an index based on a timestamp column in a given table.
Event-based data is put into this table several times a minute, with
the timestamp indicating wh
timestamp")::timestamp with time zone <=
('now'::text)::timestamp(6) with time zone))
Total runtime: 10278.628 ms
(3 rows)
monitor=# SELECT COUNT(*) FROM "eventtable";
count
425602
(1 row)
monitor=#
-- Harmon
Kevin Barnard wrote:
Harmon S. Nine wrote:
monitor=
Hello --
To increase query (i.e. select) performance, we're trying to get
postgres to use an index based on a timestamp column in a given table.
Event-based data is put into this table several times a minute, with the
timestamp indicating when a particular row was placed in the table.
The table
