[Babase] Hunter-Karl phone call

Karl O. Pinc kop at meme.com
Tue May 15 14:30:11 EDT 2007


On 05/14/2007 12:45:12 PM, Susan Alberts wrote:
> Karl,
> Hunter says that he can speak with you tomorrow (Tues) at 2 pm about  
> RAM and the slow database etc. Can you call him then?

Susan,

Just spoke with Hunter.  We figure more RAM is a good investment.
He says $200 - $300 and wants your permission before proceeding.
I'll let you two communicate directly.

Lacey,

Hunter is going to add more swap space, increasing virtual memory,
this afternoon.  Once he does so I want to try to crash PostgreSQL.
I'd like you to try running Patrick's and Marie's "bad" queries
via PPA at the same time, on two different computers,
and see if the system survives.  I'll write the list when I hear
back from Hunter.

I'd like the queires run from Duke because you've got the
fastest network connection to papio and, I think, will place the most
strain on the system.  You're surely in the best position to
evaulate the degree of slowness because network slowness is
less of a factor.

If you want you can make up your own "bad" query and run it
too.  Do you need my help to run these queries and monitor
the server or do you have the tools you need?
(Before, our problem was visable via "top" on the
line marked "Swap:".  The "free" swap would go to 0
and postfix (or something else) would crash.)

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list