Craig James wrote:
synchronous_commit = off
full_page_writes = off
I don't have any numbers handy on how much turning synchronous_commit
and full_page_writes off improves performance on a system with a
battery-backed write cache. Your numbers are therefore a bit inflated
against similar one
On Mon, Jun 28, 2010 at 1:12 PM, Craig James wrote:
> On 6/25/10 12:03 PM, Greg Smith wrote:
>>
>> Craig James wrote:
>>>
>>> I've got a new server and want to make sure it's running well.
>>
>> Any changes to the postgresql.conf file? Generally you need at least a
>> moderate shared_buffers (1GB
On 6/25/10 12:03 PM, Greg Smith wrote:
Craig James wrote:
I've got a new server and want to make sure it's running well.
Any changes to the postgresql.conf file? Generally you need at least a
moderate shared_buffers (1GB or so at a minimum) and checkpoint_segments
(32 or higher) in order for t
Craig James wrote:
I've got a new server and want to make sure it's running well.
Any changes to the postgresql.conf file? Generally you need at least a
moderate shared_buffers (1GB or so at a minimum) and checkpoint_segments
(32 or higher) in order for the standard pgbench test to give good
On Fri, Jun 25, 2010 at 2:53 PM, Craig James wrote:
> I've got a new server and want to make sure it's running well. Are these
> pretty decent numbers?
>
> 8 cores (2x4 Intel Nehalem 2 GHz)
> 12 GB memory
> 12 x 7200 SATA 500 GB disks
> 3WARE 9650SE-12ML RAID controller with BBU
> WAL on ext2, 2
I've got a new server and want to make sure it's running well. Are these
pretty decent numbers?
8 cores (2x4 Intel Nehalem 2 GHz)
12 GB memory
12 x 7200 SATA 500 GB disks
3WARE 9650SE-12ML RAID controller with BBU
WAL on ext2, 2 disks: RAID1 500GB, blocksize=4096
Database on ext4, 8 disks:
On Wed, 2005-11-02 at 21:16 +1100, Gavin Sherry wrote:
> connections are updating the branches table heavily. As an aside, did you
> initialise with a scaling factor of 10 to match your level of concurrency?
Yep, I did.
> that. The hackers list archive also contains links to the testing Mark
> Wo
On Tue, 1 Nov 2005, Joost Kraaijeveld wrote:
> Hi Gavin,
>
> Thanks for answering.
>
> On Tue, 2005-11-01 at 20:16 +1100, Gavin Sherry wrote:
> > On Tue, 1 Nov 2005, Joost Kraaijeveld wrote:
> > > 1. Is there a repository somewhere that shows results, using and
> > > documenting different kinds of
Hi Gavin,
Thanks for answering.
On Tue, 2005-11-01 at 20:16 +1100, Gavin Sherry wrote:
> On Tue, 1 Nov 2005, Joost Kraaijeveld wrote:
> > 1. Is there a repository somewhere that shows results, using and
> > documenting different kinds of hard- and software setups so that I can
> > compare my resu
On Tue, 1 Nov 2005, Joost Kraaijeveld wrote:
> Hi,
>
> I am trying to optimize my Debian Sarge AMD64 PostgreSQL 8.0
> installation, based on the recommendations from "the Annotated
> POSTGRESQL.CONF Guide for
> PostgreSQL"
> (http://www.powerpostgresql.com/Downloads/annotated_conf_80.html). To se
Hi,
I am trying to optimize my Debian Sarge AMD64 PostgreSQL 8.0
installation, based on the recommendations from "the Annotated
POSTGRESQL.CONF Guide for
PostgreSQL" (http://www.powerpostgresql.com/Downloads/annotated_conf_80.html).
To see the result of the recommendations I use pgbench from
po
Greetings all,
I'm wondering is there a website where people can submit their pgbench
results along with their hardware and configuration's? If so where are they
at? I have yet to find any. I think this could be a very useful tool not
only for people looking at setting up a new server but for peo
12 matches
Mail list logo
