Mailing List Archive: Request Tracker: Users

Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages

Index | Next | Previous | View Threaded

dxg at physics

May 28, 2012, 6:15 AM

Post #1 of 4 (618 views)
Permalink

Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages

We're running RT 4.0.4 on PostgreSQL, both installed from the Ubuntu 12.04 repository.

It's working just fine, but the performance is poor. Updating tickets with comments or replies is particularly slow. Read-performance seems to be fine, only making changes is slow.

Historically, we've run RT 3.6.5 on MySQL, and initially this had poor performance because of missing indexes. Our new RT 4 install is a fresh installation - not an upgrade, with a new database. Are there any known missing indexes on RT+PostgreSQL when installing from the Ubuntu packages?

If not, what's the best way to start diagnosing what's eating up the most time?

--
David X. Glover
IT Support, Physics
University of Oxford

ruz at bestpractical

May 28, 2012, 8:05 AM

Post #2 of 4 (589 views)
Permalink

Re: Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages [In reply to]

Hi,

Start from logs: SQL log and RT log. Timestamps in RT logs on debug
level can give you idea.

On Mon, May 28, 2012 at 5:15 PM, David X. Glover <dxg [at] physics> wrote:
> We're running RT 4.0.4 on PostgreSQL, both installed from the Ubuntu 12.04 repository.
>
> It's working just fine, but the performance is poor. Updating tickets with comments or replies is particularly slow. Read-performance seems to be fine, only making changes is slow.
>
> Historically, we've run RT 3.6.5 on MySQL, and initially this had poor performance because of missing indexes. Our new RT 4 install is a fresh installation - not an upgrade, with a new database. Are there any known missing indexes on RT+PostgreSQL when installing from the Ubuntu packages?
>
> If not, what's the best way to start diagnosing what's eating up the most time?
>
> --
> David X. Glover
> IT Support, Physics
> University of Oxford
>

--
Best regards, Ruslan.

dxg at physics

May 28, 2012, 9:10 AM

Post #3 of 4 (586 views)
Permalink

Re: Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages [In reply to]

On 28 May 2012, at 16:05, Ruslan Zakirov wrote:

> Start from logs: SQL log and RT log. Timestamps in RT logs on debug
> level can give you idea.

Good tip. I've pinned down the problem to being only when mail is sent, which would imply exim is somehow being slow...

--
David X. Glover
IT Support, Physics
University of Oxford

ruz at bestpractical

May 28, 2012, 9:42 AM

Post #4 of 4 (584 views)
Permalink

Re: Slow performance - 4.0.4 with PostgreSQL installed from Ubuntu 12.04 packages [In reply to]

On Mon, May 28, 2012 at 8:10 PM, David X. Glover <dxg [at] physics> wrote:
> On 28 May 2012, at 16:05, Ruslan Zakirov wrote:
>
>> Start from logs: SQL log and RT log. Timestamps in RT logs on debug
>> level can give you idea.
>
> Good tip. I've pinned down the problem to being only when mail is sent, which would imply exim is somehow being slow...

This is what I have suspected.

http://requesttracker.wikia.com/wiki/SendmailTips

Basicly you want exim to queue mail and don't want it do any checks
when RT calls sendmail program.

> --
> David X. Glover
> IT Support, Physics
> University of Oxford
>

--
Best regards, Ruslan.

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads