new install no database indexes

[djacob]

anyone notice the install has no indexes anymore?

its just the pkeys

 

[DigitalDaz]

I have only just noticed this now.

 

[DigitalDaz]

Dave,

Mark has confirmed this as a bug.

 

[djacob]

any idea on when he will put them back in?

 

[DigitalDaz]

None, its was dismissed exactly in that way, its a bug

 

[djacob]

here are some indexes that we use if people want them in there they can load them:

CREATE INDEX "idx_cdr_domain_uuid" ON "public"."v_xml_cdr" USING btree ("domain_uuid");
CREATE INDEX "idx_domain_name_xml_cdr" ON "public"."v_xml_cdr" USING btree ("domain_name");
CREATE INDEX "idx_v_device_keys_uuid_key_vendor" ON "public"."v_device_keys" USING btree ("device_uuid", "device_key_vendor");
CREATE INDEX "index_billsec" ON "public"."v_xml_cdr" USING btree ("billsec");
CREATE INDEX "index_caller_id_name" ON "public"."v_xml_cdr" USING btree ("caller_id_name");
CREATE INDEX "index_destination_number" ON "public"."v_xml_cdr" USING btree ("destination_number");
CREATE INDEX "index_duration" ON "public"."v_xml_cdr" USING btree ("duration");
CREATE INDEX "index_hangup_cause" ON "public"."v_xml_cdr" USING btree ("hangup_cause");
CREATE INDEX "index_start_stamp" ON "public"."v_xml_cdr" USING btree ("start_stamp");

hope this helps anyone.
thanks
Dave