Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Marlowe
Subject Re: understanding postgres issues/bottlenecks
Date
Msg-id dcc563d10901061045x642b486dyf642f27535f817ba@mail.gmail.com
Whole thread Raw
In response to understanding postgres issues/bottlenecks  (Stefano Nichele <stefano.nichele@gmail.com>)
Responses Re: understanding postgres issues/bottlenecks
List pgsql-performance
Tree view 
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?

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?

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: understanding postgres issues/bottlenecks
Next
From: "Scott Marlowe"
Date:
Subject: Re: failure notice