Re: [rt-users] How to add attachments (not links) with a template to an outgoing mail?

2009-11-20 Thread Brumm, Torsten / Kuehne + Nagel / Ham MI-ID
Hi Tom, thanks for the hint. in the mean time we found a easy way to do this ;-) Torsten Kuehne + Nagel (AG Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt

[rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Dominic Hargreaves
I'm migrating from an RT 2 install to an RT 3.8 install with around 170 privileged users (and around 90,000 total users). I've done some initial testing with RT 3.8.6 and have observed that building the list of privileged users (in the create new ticket (ticket owner), display ticket (reminder

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Dominic Hargreaves
On Fri, Nov 20, 2009 at 11:41:50AM +, Dominic Hargreaves wrote: I'm migrating from an RT 2 install to an RT 3.8 install with around 170 privileged users (and around 90,000 total users). I've done some initial testing with RT 3.8.6 and have observed that building the list of privileged

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Kenneth Marshall
On Fri, Nov 20, 2009 at 11:41:50AM +, Dominic Hargreaves wrote: I'm migrating from an RT 2 install to an RT 3.8 install with around 170 privileged users (and around 90,000 total users). I've done some initial testing with RT 3.8.6 and have observed that building the list of privileged

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Dominic Hargreaves
On Fri, Nov 20, 2009 at 08:02:46AM -0600, Kenneth Marshall wrote: On Fri, Nov 20, 2009 at 11:41:50AM +, Dominic Hargreaves wrote: I'm migrating from an RT 2 install to an RT 3.8 install with around 170 privileged users (and around 90,000 total users). I've done some initial testing

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Jesse Vincent
Here most of the time is spent in the hash join for: Hash Cond: (cachedgroupmembers_2.memberid = main.id) What indexes do you have on cachedgroupmembers? (Also, I presume your Postgres is reasonably well tuned, autovacuumed, etc) ___

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Dominic Hargreaves
On Fri, Nov 20, 2009 at 11:16:08AM -0500, Jesse Vincent wrote: What indexes do you have on cachedgroupmembers? cachedgroupmembers_pkey PRIMARY KEY, btree (id) cachedgroupmembers2 btree (memberid) cachedgroupmembers3 btree (groupid) disgroumem btree (groupid, memberid, disabled)

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Kenneth Marshall
On Fri, Nov 20, 2009 at 04:14:52PM +, Dominic Hargreaves wrote: On Fri, Nov 20, 2009 at 08:02:46AM -0600, Kenneth Marshall wrote: On Fri, Nov 20, 2009 at 11:41:50AM +, Dominic Hargreaves wrote: I'm migrating from an RT 2 install to an RT 3.8 install with around 170 privileged

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Dominic Hargreaves
On Fri, Nov 20, 2009 at 10:30:32AM -0600, Kenneth Marshall wrote: On Fri, Nov 20, 2009 at 04:14:52PM +, Dominic Hargreaves wrote: The indexes we have defined are the standard ones from the 3.8.6 schemas, plus one of the two I already posted: CREATE INDEX Groups3 ON Groups

[rt-users] Scrip to remove requestors based on group membership

2009-11-20 Thread darthmarth37
I'm trying to write a scrip that removes the requestor of a new ticket if the requestor's email address is in a specific no-reply group in RT (for things like Nagios messages that don't need replies), and I think I'm getting confused when trying to make it work. What I have so far (below) doesn't

Re: [rt-users] How to add attachments (not links) with a template to an outgoing mail?

2009-11-20 Thread Tom Lahti
Brumm, Torsten / Kuehne + Nagel / Ham MI-ID wrote: Hi Tom, thanks for the hint. in the mean time we found a easy way to do this ;-) Torsten Out of curiousity, what is that easy way, in case we ever need that here? -- -- Tom Lahti, SCMDBA, LPIC-1 BIT LLC (425)251-0833 x 117

Re: [rt-users] Update Ticket takes too long

2009-11-20 Thread Kevin Falcone
On Tue, Nov 17, 2009 at 05:20:53PM +, Rui Vitor Figueiras Meireles wrote: Thank you. I believe it was a DNS problem. I have a scrip to send e-mail notifications to all members of a certain group whenever a new ticket is posted in a certain queue. However, there was only 1 member in