PSA: indexes and high CPU usage

Development-related discussion, including bundled plugins
Masiosare
Bear Rating Trainee
Bear Rating Trainee
Posts: 22
Joined: 23 May 2013, 01:08

PSA: indexes and high CPU usage

Postby Masiosare » 21 Jan 2015, 00:23


User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: PSA: indexes and high CPU usage

Postby sleeper_service » 21 Jan 2015, 02:04

mine already had an index on guid...

'course I'm running postgres like a good little ttrsser, dunno if that matters.

User avatar
ZeGuigui
BANNED_USERS
BANNED_USERS
Posts: 19
Joined: 15 Mar 2013, 17:30
Location: In the cloud!
Contact:

Re: PSA: indexes and high CPU usage

Postby ZeGuigui » 21 Jan 2015, 11:43

I also have the index using MySQL

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: PSA: indexes and high CPU usage

Postby fox » 21 Jan 2015, 11:51

why is everything that starts with psa: is inevitably something dumb?

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: PSA: indexes and high CPU usage

Postby sleeper_service » 21 Jan 2015, 17:42


Masiosare
Bear Rating Trainee
Bear Rating Trainee
Posts: 22
Joined: 23 May 2013, 01:08

Re: PSA: indexes and high CPU usage

Postby Masiosare » 22 Jan 2015, 02:55


JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: PSA: indexes and high CPU usage

Postby JustAMacUser » 22 Jan 2015, 03:34

Duplicate indexes were dropped. guid is UNIQUE which makes it indexed.

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: PSA: indexes and high CPU usage

Postby sleeper_service » 22 Jan 2015, 04:43


User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: PSA: indexes and high CPU usage

Postby fox » 22 Jan 2015, 11:49


User avatar
blainemono
Gaping Anus of Eternity
Gaping Anus of Eternity
Posts: 246
Joined: 05 Jun 2009, 18:13

Re: PSA: indexes and high CPU usage

Postby blainemono » 22 Jan 2015, 13:36

also fuck you

User avatar
blainemono
Gaping Anus of Eternity
Gaping Anus of Eternity
Posts: 246
Joined: 05 Jun 2009, 18:13

Re: PSA: indexes and high CPU usage

Postby blainemono » 22 Jan 2015, 13:36

also everyone else I guess, what the hell

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: PSA: indexes and high CPU usage

Postby sleeper_service » 22 Jan 2015, 18:55



Return to “Development”

Who is online

Users browsing this forum: No registered users and 1 guest