On Wed, Nov 25, 2009 at 11:25:02AM -0500, Jesse Vincent wrote:
I think your suggested new index in group is correct; that's
eliminated some more slow queries. I think I'll try and put up a
set of annotated additional postgres indexes on the wiki, in lieu
of future updates to the indexes
I think your suggested new index in group is correct; that's
eliminated some more slow queries. I think I'll try and put up a
set of annotated additional postgres indexes on the wiki, in lieu
of future updates to the indexes created by the schemas shipped with
RT.
(And possibly influencing
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
Hi
I am noticing from my slow log file (5 secs) that the following query
on mysql 4.0.24 is taking a 11 secs
# Query_time: 11 Lock_time: 0 Rows_sent: 299925 Rows_examined: 983836
use rt3;
SELECT * FROM Transactions where Transactions.type = 'create';
Now looking at the explain I see
mysql
11 matches
Mail list logo