Re: understanding postgres issues/bottlenecks

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Stefano Nichele" <stefano(dot)nichele(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: understanding postgres issues/bottlenecks
Date: 2009-01-06 18:45:45
Message-ID: dcc563d10901061045x642b486dyf642f27535f817ba@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-01-06 18:59:02 Re: failure notice
Previous Message Merlin Moncure 2009-01-06 17:16:46 Re: understanding postgres issues/bottlenecks