Postgres Pro
Downloads
Home   >   mailing lists

Re: understanding postgres issues/bottlenecks - Mailing list pgsql-performance

From Stefano Nichele
Subject Re: understanding postgres issues/bottlenecks
Date
Msg-id bdb13b210901071302t1ef71ad0wb17408e7cca00a2d@mail.gmail.com
Whole thread Raw
In response to Re: understanding postgres issues/bottlenecks  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: understanding postgres issues/bottlenecks  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view

On Tue, Jan 6, 2009 at 7:45 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
I concur with Merlin you're I/O bound.

Adding to his post, what RAID controller are you running, does it have
cache, does the cache have battery backup, is the cache set to write
back or write through?
 
At the moment I don't have such information. It's a "standard" RAID controller coming with a DELL server. Is there any information I can have asking to the SO ?



Also, what do you get for this (need contrib module pgbench installed)

pgbench -i -s 100
pgbench -c 50 -n 10000

? Specifically transactions per second?

I'll run pgbench in the next days.

Cheers,
ste

pgsql-performance by date:

Previous
From: Stefano Nichele
Date:
Subject: Re: understanding postgres issues/bottlenecks
Next
From: "Scott Marlowe"
Date:
Subject: Re: understanding postgres issues/bottlenecks