Re: Configuration settings (shared_buffers, etc) in Linux: puzzled

From: Fernando Ike <fike(at)midstorm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuration settings (shared_buffers, etc) in Linux: puzzled
Date: 2008-01-25 01:53:52
Message-ID: 20080124235352.7babcafe@pmanson
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Em Thu, 24 Jan 2008 13:00:24 -0500
Rick Schumeyer <rschumeyer(at)ieee(dot)org> escreveu:

> On a linux box (Linux db1 2.6.18.8-md #1 SMP Wed May 23 17:21:37 EDT
> 2007 i686 GNU/Linux)
> I edited postgresql.conf and changed:
>
> shared_buffers = 5000 work_mem = 16384
> max_stack_depth = 4096
>

This configuration is possibility of the PostgreSQL 8.1. But if don't
by 8.1, for example: 8.2 or 8.3, follow the talk Greg Smith. :)

Best Regards,
--
Fernando Ike
http://www.midstorm.org/~fike/weblog

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-01-25 02:27:01 Re: planner chooses unoptimal plan on joins with complex key
Previous Message Fernando Ike 2008-01-25 01:14:33 Re: 8.3rc1 Out of memory when performing update