array_agg(col1 order by col2) is failing for huge amount of data

Hello there...

array_agg(col1 order by col2) is failing for huge amount of data

Some of the observation is as follows-------------

the data array for timestamp is not comming in sorted order while executing
the following query


SELECT  host, service, resourcetype, metrictype, array_agg(metricvalue
order by timestamp1) AS metricvalue, array_agg(sla order by timestamp1) as
slavalues, array_agg(timestamp1) as timestamp from servicemetrics where
timestamp1 between 1339046856 and 1370582856 and metricvalue is not null
and resourceType=3D'server' GROUP BY host, resourcetype, service, metrictyp=
e



     host     |  service   | resourcetype | metrictype
|
metricvalue
|
slavalues
|
timestamp

--------------+------------+--------------+------------+-------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
------------------------------------+--------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
-------------------------------------------+-------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------------------------------
 192.168.1.46 | merit_mail | server       | auxfan     |
{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,=
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0=
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}
|
{25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25=
,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25=
,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25=
,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25=
,25}
|
{1370237078,1370247349,1370237103,1370247385,1370237108,1370247366,13702371=
12,1370247380,1370237137,1370247340,1370237122,1370247344,1370237141,137024=
7404,1370237160,1370247409,1370237151,1370247399,1370237146,1370247394,1370=
237156,1370247390,1370237175,1370247428,1370237184,1370247353,1370237180,13=
70247361,1370237189,1370247433,1370237194,1370247423,1370237198,1370247440,=
1370237203,1370247445,1370237073,1370247450,1370237069,1370247464,137023706=
4,1370247469,1370237059,1370247473,1370237054,1370247478,1370237222,1370247=
483,1370237218,1370247487,1370237098,1370247492,1370237093,1370247506,13702=
37117,1370247511,1370236847,1370247516,1370236853,1370247520,1370236862,137=
0247535,1370236858,1370247539,1370236867,1370247544,1370236872,1370247561,1=
370236876,1370247549,1370236881,1370247553,1370236886,1370247565,1370236890=
,1370247580,1370236905,1370247585,1370236910,1370247591,1370236915,13702369=
20,1370236925,1370236930,1370236935,1370236940,1370236945,1370236949,137023=
6954,1370236969,1370236974,1370236979,1370237015,1370236985,1370237005,1370=
236990,1370237010,1370237020,1370237049,1370237025,1370237030}





--=20
Anand Kumar Verma