Raid installed and no performace improvement at housekeeping

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Re: Raid installed and no performace improvement at housekeeping

Postby zubs1aa » Fri Jun 25, 2010 4:58 pm

kraada wrote:When it says "Populating" it means that PT3 is actually formatting the report; the SQL query is run during the time it says "Loading".


Is that the same for tab loads? Like when yo uboot up PT and the tourney tab shows and the player list is populating for 5 minutes?
zubs1aa
 
Posts: 2219
Joined: Fri Feb 08, 2008 1:52 pm

Re: Raid installed and no performace improvement at housekeeping

Postby kraada » Fri Jun 25, 2010 6:14 pm

As far as I know that's universal.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Raid installed and no performace improvement at housekeeping

Postby zubs1aa » Fri Jun 25, 2010 7:32 pm

kraada wrote:As far as I know that's universal.


OK then what is the limiting factor(s) for why it takes so flippin long to load that list the first time?

Also, it seems that the *this month* filter takes much longer then specifying the precise between dates for the month
zubs1aa
 
Posts: 2219
Joined: Fri Feb 08, 2008 1:52 pm

Re: Raid installed and no performace improvement at housekeeping

Postby kraada » Sat Jun 26, 2010 8:49 am

Honestly I'm not sure - but you attach a log to a ticket highlighting that problem we can look at the timestamps and see where it's stuck, then go from there.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 33 guests

cron