[Treebase-devel] Fwd: Disk space for treebase production database

[Jon A. <jon...@ne...>]

> From: Jon Auman <jon...@ne...>
> Date: September 15, 2010 9:28:10 AM EDT
> To: William Piel <wil...@ya...>
> Subject: Re: [Treebase-devel] Disk space for treebase production database
> 
> I rebooted the server. Postgresql was hung and eating all of the CPUs. I think what happens is that someone generates a query that never finishes through the application. That person then probably restarts the browser and tires again. The end result is multiple hanged queries which eats up all the CPU time. 
> 
> As fas as I see it, the solutions would be:
> 1) improve the queries (probably not going to happen until more funding is secured)
> 2) look into some kind of cacheing
> 3) bring up another database server for load balancing.
> 4) kill queries after x minutes. I thought I had that configured, but it seems that there are some instances where that doesn't happen.
> 
> I'll look into #4 some more, as that is the easiest "fix". Do you have any thoughts on this?
> 
> -Jon
> 
>  
> On Sep 15, 2010, at 9:17 AM, William Piel wrote:
> 
>> 
>> On Sep 14, 2010, at 10:53 PM, William Piel wrote:
>> 
>>> Hi Jon,
>>> 
>>> Speaking of speed issues, I'm trying to edit some submissions (Sept 14, between 9PM and 11PM EST) but I'm finding it very slow... so slow, in fact, that it's barely able to function. I don't know if there's some backup activity going on... but I just thought I'd mention it.
>>> 
>>> bp
>> 
>> This morning (9 AM EST) it back up to normal speed.
>> 
>> bp
>> 
>> 
>> 
>> ------------------------------------------------------------------------------
>> Start uncovering the many advantages of virtual appliances
>> and start using them to simplify application deployment and
>> accelerate your shift to cloud computing.
>> http://p.sf.net/sfu/novell-sfdev2dev
>> _______________________________________________
>> Treebase-devel mailing list
>> Tre...@li...
>> https://lists.sourceforge.net/lists/listinfo/treebase-devel
> 
> -------------------------------------------------------
> Jon Auman
> Systems Administrator
> National Evolutionary Synthesis Center
> Duke University
> http:www.nescent.org
> jon...@ne...
> ------------------------------------------------------
> 
> 
> 

-------------------------------------------------------
Jon Auman
Systems Administrator
National Evolutionary Synthesis Center
Duke University
http:www.nescent.org
jon...@ne...
------------------------------------------------------