Postgres Pro
Downloads
Home   >   mailing lists

Re: Configuration settings (shared_buffers, etc) in Linux: puzzled - Mailing list pgsql-performance

From Fernando Ike
Subject Re: Configuration settings (shared_buffers, etc) in Linux: puzzled
Date
Msg-id 20080124235352.7babcafe@pmanson
Whole thread Raw
In response to Configuration settings (shared_buffers, etc) in Linux: puzzled  (Rick Schumeyer <rschumeyer@ieee.org>)
List pgsql-performance
Tree view 
Em Thu, 24 Jan 2008 13:00:24 -0500
Rick Schumeyer <rschumeyer@ieee.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

pgsql-performance by date:

Previous
From: Fernando Ike
Date:
Subject: Re: 8.3rc1 Out of memory when performing update
Next
From: Tom Lane
Date:
Subject: Re: planner chooses unoptimal plan on joins with complex key