Re: High update activity, PostgreSQL vs BigDBMS - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: High update activity, PostgreSQL vs BigDBMS
Date
Msg-id 1168145807.869.22.camel@localhost.localdomain
Whole thread Raw
In response to Re: High update activity, PostgreSQL vs BigDBMS  (Guy Rouillier <guyr-ml1@burntmail.com>)
List pgsql-performance
> Regarding shared_buffers=750MB, the last discussions I remember on this
> subject said that anything over 10,000 (8K buffers = 80 MB) had unproven
> benefits.  So I'm surprised to see such a large value suggested.  I'll
> certainly give it a try and see what happens.
>

That is old news :) As of 8.1 it is quite beneficial to go well above
the aforementioned amount.

J


> >>
> >> autovacuum=on
> >> stats_row_level = on
> >> max_connections = 10
> >> listen_addresses = 'db01,localhost'
> >> shared_buffers = 128MB
> >> work_mem = 16MB
> >> maintenance_work_mem = 64MB
> >> temp_buffers = 32MB
> >> max_fsm_pages = 204800
> >> checkpoint_segments = 30
> >> redirect_stderr = on
> >> log_line_prefix = '%t %d'
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




pgsql-performance by date:

Previous
From: "Colin Taylor"
Date:
Subject: table partioning performance
Next
From: "Craig A. James"
Date:
Subject: Re: High update activity, PostgreSQL vs BigDBMS