On Thu, Aug 19, 2010 at 4:23 AM, Philippe Rimbault <primbault@xxxxxx> wrote: >> So how are the disks setup anyway? >> > > Thanks for your reply ! > > The server use a HP Smart Array P410 with a Raid 5 array on Sata 133 disk. If you can change that to RAID-10 do so now. RAID-5 is notoriously slow for database use, unless you're only gonna do reporting type queries with few updates. > My desktop only use one Sata 133 disk. > I was thinking that my simples queries didn't use disk but only memory. No, butt pgbench has to write to the disk. > I've launch a new pgbench with much more client and transactions : > > Server : > postgres$ pgbench -c 400 -t 100 -c 400 is HUGE. (and as you mentioned in your later email, you need to -s -i 400 for -c 400 to make sense) Try values in the 4 to 40 range and the server should REALLY outshine your desktop as you pass 12 or 16 or so. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
