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

2003-09-05 Thread Richard Huxton
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 rows now and grows by app. 350k rows a day. > > The ID-column holds about 1500 unique values (integer). > The TIME-

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

2003-09-04 Thread Rasmus Aveskogh
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