Re: [PERFORM] SCSI vs SATA

2007-04-05 Thread Richard Troy
ves are now serving our gateway / firewall systems (of which we have several), while our newest are providing primary daily workhorse service, and middle-aged are serving hot-backup duty. Perhaps you could argue that this putting out to pasture isn't comparable to heavy 24/7/356 deman

Re: [PERFORM] Estimate the size of the SQL file generated by pg_dump utility

2007-03-06 Thread Richard Troy
patch submission making them fit whatever legal model is desired would avoid any and all legal issues related to legalease included with a submission. The would-be patcher's action of submission can also count as acknowledgement of the actual agreement - your agreement - if you've got the p

Re: [PERFORM] Postgres server crash

2006-11-18 Thread Richard Troy
t getting itself into a potentially hung situation because it didn't save itself any memory. Frankly, if it takes a complete kernel rewrite to fix the problem that the damned operating system can't manage its own needs, then the kernel needs to be rewritten! These kernel hackers cou

Re: [PERFORM] Context switch storm

2006-11-03 Thread Richard Troy
systems is a multi-cpu Xeon based system of uncertain age (nobody remember 'zactly). While we haven't seen this problem yet, it's scheduled to take over demo-duty shortly and it would be an embarassment if we had this trouble during a demo... Is there any easy way to tell if you'

Re: [PERFORM] commit so slow program looks frozen

2006-10-26 Thread Richard Troy
s) and they hated it. What happened was PERL got exposure that TCL didn't and people who didn't know better jumped on it. So, it was one of the most complete interfaces because it was done first, or nearly first, by the original guys that created the original Postgres. Richard -- Richard Tr

Re: [PERFORM] commit so slow program looks frozen

2006-10-26 Thread Richard Troy
your machine is spending more time on overhead than doing user work - this would include paging or context switching, along with whatever else. A context-switch storm would be a specific form of thrashing! Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-7