X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6CD7A9DC810 for ; Mon, 19 Dec 2005 16:11:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36383-09 for ; Mon, 19 Dec 2005 16:11:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.197]) by postgresql.org (Postfix) with ESMTP id 243409DC801 for ; Mon, 19 Dec 2005 16:11:03 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so876887wxc for ; Mon, 19 Dec 2005 12:11:05 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=BOFNp5Y8BnA/XNjKzxFKXqqoNN8EIq2m0oGYY7hkn3jHOTWyYEZr9YKDPr7wKirl0E3qzfL6NaNnu32GuXESu+QwT2yLLUR+Fpre3kFOXIxFtP/PeY/bf3NCfs98e3JWAh669dQUywngDY1x2SowNO05oL7cadAyZ58IOsL2WfY= Received: by 10.70.41.7 with SMTP id o7mr4951820wxo; Mon, 19 Dec 2005 12:11:04 -0800 (PST) Received: by 10.70.84.7 with HTTP; Mon, 19 Dec 2005 12:11:04 -0800 (PST) Message-ID: <1d219a6f0512191211n17f39110i2fb7413593930a5d@mail.gmail.com> Date: Mon, 19 Dec 2005 15:11:04 -0500 From: Chris Hoover To: "pgsql-admin@postgresql.org" Subject: PG8.1 - Config file check MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.017 required=5 tests=[AWL=0.017] X-Spam-Score: 0.017 X-Spam-Level: X-Archive-Number: 200512/203 X-Sequence-Number: 19923 We are in the process of upgrading our 7.3.4 servers to 8.1, and I wanted to have a sanity check ran against my config file. Do you see any issues with these configs? Our servers are Dell 2650/2850's with dual processors and 8-12 GB memory. postgresql.conf listen_addresses =3D '*' # what IP address(es) to listen on; max_connections =3D 256 shared_buffers =3D 32768 # min 16 or max_connections*2, 8K= B each max_prepared_transactions =3D 256 # can be 0 or more work_mem =3D 4096 # min 64, size in KB maintenance_work_mem =3D 1048576 # min 1024, size in KB max_fsm_pages =3D 8000000 # min max_fsm_relations*16, 6 byt= es each max_fsm_relations =3D 5000 # min 100, ~70 bytes each vacuum_cost_delay =3D 10 # 0-1000 milliseconds vacuum_cost_limit =3D 1000 # 0-10000 credits wal_buffers =3D 64 # min 4, 8KB each checkpoint_segments =3D 256 # in logfile segments, min 1, 16M= B each checkpoint_timeout =3D 1800 # range 30-3600, in seconds effective_cache_size =3D 766980 # typically 8KB each random_page_cost =3D 2 # units are one sequential page f= etch constraint_exclusion =3D on redirect_stderr =3D on # Enable capturing of stderr into= log log_directory =3D 'pg_log' # Directory where log files are w= ritten log_truncate_on_rotation =3D on # If on, any existing log file of the same log_rotation_age =3D 1440 # Automatic rotation of logfiles = will log_rotation_size =3D 0 # Automatic rotation of logfiles = will log_min_duration_statement =3D 0 # -1 is disabled, 0 logs all stat= ements log_connections =3D on log_disconnections =3D on log_duration =3D on log_line_prefix =3D '%d,%u,%p,%m,%c,%l,%s,%x,%i,' # Special values: log_statement =3D 'all' # none, mod, ddl, all stats_start_collector =3D on stats_command_string =3D on stats_block_level =3D on stats_row_level =3D on stats_reset_on_server_start =3D on autovacuum =3D off # enable autovacuum subprocess? lc_messages =3D 'C' # locale for system error message lc_monetary =3D 'C' # locale for monetary formatting lc_numeric =3D 'C' # locale for number formatting lc_time =3D 'C' # locale for time formatting add_missing_from =3D on I have upped the following parameters to help speed up our conversions, is there any issues leaving them set to these values after our conversion to 8.1? maintenance_work_mem to 1GB (1048576) checkpoint_segements to 256 checkpoint_timeout to 1800 seconds (30 minutes) Thanks, Chris