Index in source and message tables

Support
#1

Hi,

the DBA at the company that I work wants to remove index from the sources
and messages table to evaluate some performance issues that we are
having… should I be concerned with this change?

Thanks in advance,
Gus

#2

> Hi,
>
> the DBA at the company that I work wants to remove index from the sources
> and messages table to evaluate some performance issues that we are
> having… should I be concerned with this change?
>
> Sources and Messages are tables that contain the actual text of a report.

since many times you get the same messages, we dont store multiple copies
of that (so its easier to search etc).

removing the index would cause longer time to parse the report, will
probably not break anything, but you might see longer puppet runs because
it takes longer for foreman to process the reports…

Ohad

··· On Tue, Nov 13, 2012 at 8:34 PM, Gustavo Soares wrote:

Thanks in advance,
Gus

–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.

#3

Thank you Ohad.

··· On Tue, Nov 13, 2012 at 4:52 PM, Ohad Levy wrote:

On Tue, Nov 13, 2012 at 8:34 PM, Gustavo Soares gustavosoares@gmail.comwrote:

Hi,

the DBA at the company that I work wants to remove index from the sources
and messages table to evaluate some performance issues that we are
having… should I be concerned with this change?

Sources and Messages are tables that contain the actual text of a report.

since many times you get the same messages, we dont store multiple copies
of that (so its easier to search etc).

removing the index would cause longer time to parse the report, will
probably not break anything, but you might see longer puppet runs because
it takes longer for foreman to process the reports…

Ohad

Thanks in advance,
Gus

–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.

–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.