Re: [PERFORM] Performance problems on a fairly big table with two

etween 10ms and 200ms. Thanks again! -ra > On Thursday 04 September 2003 23:53, Rasmus Aveskogh wrote: >> Hi, >> >> I have a table that looks like this: >> >> DATA ID TIME >> >> |--||--| >> >> The table holds app. 14M

[PERFORM] Performance problems on a fairly big table with two key columns.

Hi, I have a table that looks like this: DATA ID TIME |--||--| The table holds app. 14M rows now and grows by app. 350k rows a day. The ID-column holds about 1500 unique values (integer). The TIME-columns is of type timestamp without timezone. I have one index (b-tree) on th