Martin Edenhofer schrieb:
Attached it the postgresql create script for OTRS 1.3 with your performace improvements.
I created the following, additional indexes for PostgreSQL. I don't know if they all are useful and necessary, but am experiencing speed improvements. Sorry, the used naming scheme might be better. Regards, Robert Kehl CREATE INDEX article_attachment_filename_index ON public.article_attachment USING btree (filename); CREATE INDEX article_attachment_content_type_index ON public.article_attachment USING btree (content_type); CREATE INDEX article_attachment_content_size_index ON public.article_attachment USING btree (content_size); CREATE INDEX article_plain_article_id_index ON public.article_plain USING btree (article_id); CREATE INDEX generic_agent_jobs_job_name_index ON public.generic_agent_jobs USING btree (job_name); CREATE INDEX group_customer_user_user_id_index ON public.group_customer_user USING btree (user_id); CREATE INDEX group_customer_user_group_id_index ON public.group_customer_user USING btree (group_id); CREATE INDEX group_role_role_id_index ON public.group_role USING btree (role_id); CREATE INDEX group_user_user_id_index ON public.group_user USING btree (user_id); CREATE INDEX group_user_group_id_index ON public.group_user USING btree (group_id); CREATE INDEX notifications_notification_type_index ON public.notifications USING btree (notification_type); CREATE INDEX personal_queues_user_id_index ON public.personal_queues USING btree (user_id); CREATE INDEX personal_queues_queue_id_index ON public.personal_queues USING btree (queue_id); CREATE INDEX postmaster_filter_f_name_index ON public.postmaster_filter USING btree (f_name); CREATE INDEX queue_group_id_index ON public.queue USING btree (group_id); CREATE INDEX queue_system_address_id_index ON public.queue USING btree (system_address_id); CREATE INDEX queue_auto_response_queue_id_index ON public.queue_auto_response USING btree (queue_id); CREATE INDEX queue_auto_response_auto_response_id_index ON public.queue_auto_response USING btree (auto_response_id); CREATE INDEX queue_standard_response_queue_id_index ON public.queue_standard_response USING btree (queue_id); CREATE INDEX queue_standard_response_standard_response_id_index ON public.queue_standard_response USING btree (standard_response_id); CREATE INDEX role_user_role_id_index ON public.role_user USING btree (role_id); CREATE INDEX role_user_user_id_index ON public.role_user USING btree (user_id); CREATE INDEX search_profile_login_index ON public.search_profile USING btree (login); CREATE INDEX search_profile_name_index ON public.search_profile USING btree (profile_name); CREATE INDEX session_session_id_index ON public.session USING btree (session_id); CREATE INDEX standard_response_attachment_standard_attachment_id_index ON public.standard_response_attachment USING btree (standard_attachment_id); CREATE INDEX standard_response_attachment_standard_response_id_index ON public.standard_response_attachment USING btree (standard_response_id); CREATE INDEX system_address_queue_id_index ON public.system_address USING btree (queue_id); CREATE INDEX ticket_queue_id_index ON public.ticket USING btree (queue_id); CREATE INDEX ticket_group_id_index ON public.ticket USING btree (group_id); CREATE INDEX ticket_history_article_id_index ON public.ticket_history USING btree (article_id); CREATE INDEX ticket_index_queue_id_index ON public.ticket_index USING btree (queue_id); CREATE INDEX ticket_index_group_id_index ON public.ticket_index USING btree (group_id); CREATE INDEX ticket_link_ticket_id_master_index ON public.ticket_link USING btree (ticket_id_master); CREATE INDEX ticket_link_ticket_id_slave_index ON public.ticket_link USING btree (ticket_id_slave); CREATE INDEX ticket_state_for_type_id_index ON public.ticket_state USING btree (type_id); CREATE INDEX time_accounting_article_id_index ON public.time_accounting USING btree (article_id);