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
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
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
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
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
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)
___
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)
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
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
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
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
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
12 matches
Mail list logo