Re: [PERFORM] setting up raid10 with more than 4 drives

2007-05-31 Thread Sander Steffann
Hi, Op 1-jun-2007, om 1:39 heeft Steinar H. Gunderson het volgende geschreven: On Wed, May 30, 2007 at 12:41:46AM -0400, Jonah H. Harris wrote: Yeah, I've never seen a way to RAID-1 more than 2 drives either. pannekake:~> grep -A 1 md0 /proc/mdstat md0 : active raid1 dm-20[2] dm-19[1] dm-18

Re: [PERFORM] setting up raid10 with more than 4 drives

2007-05-31 Thread Steinar H. Gunderson
On Wed, May 30, 2007 at 12:41:46AM -0400, Jonah H. Harris wrote: > Yeah, I've never seen a way to RAID-1 more than 2 drives either. pannekake:~> grep -A 1 md0 /proc/mdstat md0 : active raid1 dm-20[2] dm-19[1] dm-18[0] 64128 blocks [3/3] [UUU] It's not a big device, but I can ensure you it

Re: [PERFORM] max_fsm_pages, shared_buffers and checkpoint_segments

2007-05-31 Thread Vivek Khera
On May 23, 2007, at 4:40 PM, Peter Schuller wrote: Sounds like you need to increase your shared memory limits. Unfortunately this will require a reboot on FreeBSD :( No, it does not. You can tune some of the sysv IPC parameters at runtime. the shmmax and shmall are such parameters.

Re: [PERFORM] Some info to share: db_STRESS Benchmark results

2007-05-31 Thread Dimitri
Well, let's say I want to have compact graphs :) So, few comments on graphs: - Title: compact name of test and execution conditions - X-axis: is always representing time scale - Y-axis: is showing a value level (whatever) - Legend: gives you a value Name and its metric (KB/s, Op/s, TPS, etc)

Re: [PERFORM] Some info to share: db_STRESS Benchmark results

2007-05-31 Thread Alexander Staubo
On 5/31/07, Dimitri <[EMAIL PROTECTED]> wrote: just wanted to share some benchmark results from one long performance study comparing MySQL, PostgreSQL and Oracle transactions throughput and engine scalability on T2000 and V890 (under Solaris). Interesting, if awfully cryptic. The lack of axis l

[PERFORM] Some info to share: db_STRESS Benchmark results

2007-05-31 Thread Dimitri
Folks, just wanted to share some benchmark results from one long performance study comparing MySQL, PostgreSQL and Oracle transactions throughput and engine scalability on T2000 and V890 (under Solaris). Oracle results are removed (of course :), but other are quite interesting... Findings are pre

Re: [PERFORM] DB cluster sharing between 32 and 64 bit software versions

2007-05-31 Thread Bill Moran
In response to Ireneusz Pluta <[EMAIL PROTECTED]>: > Hello, > > I am going to build a new PostgreSQL dedicated server, on FreeBSD. Before it > goes to production > service I need to make some tests and take configuration decisions, focused > on my application needs. > Usual thing. One of them

[PERFORM] DB cluster sharing between 32 and 64 bit software versions

2007-05-31 Thread Ireneusz Pluta
Hello, I am going to build a new PostgreSQL dedicated server, on FreeBSD. Before it goes to production service I need to make some tests and take configuration decisions, focused on my application needs. Usual thing. One of them is selection of one of 32 or 64 bit versions of both OS and PG. Wh

Re: [PERFORM] Bad RAID1 read performance

2007-05-31 Thread Albert Cervera Areny
As you suggested with two threads I get 42.39 Mb/s in one and 40.70 Mb/s in the other one, so that's more than 80Mb/s. That's what I expected with a single thread, so thanks for the information. It seems I will have to buy better hard drives if I want increased performance... A Dimecres 30 Maig