Re: understanding postgres issues/bottlenecks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Tue, Jan 6, 2009 at 7:45 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux