Re: [PERFORM] New hardware thoughts

o to hell. --- flame off good luck! regards, alvis ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PERFORM] Configuring System for Speed

here, no matter how minimal, would be appreciated. My answer is FreeBSD6.1. Thanks, Brian Wipf ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Best Regards, Alvis ---(end of broadcast)-

Re: [PERFORM] Dell PowerEdge 2950 performance

s 60us 1.93c,1.93c,raid0,1,1155819725,16000M,,262,99,116527,38,26451,12,495,99,135301,46,323.5,15,16,5837,19,+,+++,+,+++,3463,11,+,+++,+,+++,32978us,323ms,242ms,23842us,171ms,1370ms,555ms,422us,43us,1023ms,52us,60us -- Best Regards, alvis ---(end o

Re: [PERFORM] Selects query stats?

try pgtop. It is mytop clone for postgresql. Regards, alvis Francisco Reyes wrote: I am not sure if this is what the original poster was refering to, but I have used an application called mtop that shows how many queries per second mysql is doing. In my case this is helpfull because we have

Re: [PERFORM] Sorting a query on a view ignores an index

ar (rarely) so it is essential part of my dbvs. Maybe my exp. will encourage somebody to play with scary genetic stuff. ;-) Good luck & Best Regards, Alvis ---(end of broadcast)--- TIP 8: explain analyze is your friend

[PERFORM] When NOT to index small tables?

inner join on common_column .. I have migrated from mysql . I have found that complex view expression takes about 10 sec using ordinary planner, but genetic alg takes about 5 sec. Strange? I can give details if someone is interested. Regards, Alvis ---(end of