X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 16A1C9FB343 for ; Mon, 31 Jul 2006 13:35:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 06898-01 for ; Mon, 31 Jul 2006 13:35:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 53F179FB306 for ; Mon, 31 Jul 2006 13:34:43 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: PostgreSQL hanging X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Mon, 31 Jul 2006 10:34:42 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: PostgreSQL hanging Thread-Index: Aca0ux0lGXTrVj75QqWzUQXOpeM2XwAAkCIQ From: "Benjamin Krajmalnik" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=AWL, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/294 X-Sequence-Number: 22540 I am runing PG 8.1.4/Windows. Over the weekend, I have had to restart the PostgreSQL service a couple of times after PG hangs. At the time this happens, the log is showing entries such as the one below 2006-07-31 09:19:55 LOG: could not rename file "pg_xlog/0000000100000208000000E1" to "pg_xlog/0000000100000208000000F4", continuing to try=20 Any ideas what may be causing this? My database is currently 7.7 GB. I have 54GB of drive space available, so it is not being caused by lack of disk space. My autovacuum parameters are as follows: #----------------------------------------------------------------------- ---- # AUTOVACUUM PARAMETERS #----------------------------------------------------------------------- ---- autovacuum =3D on # enable autovacuum subprocess? autovacuum_naptime =3D 20 # time between autovacuum runs, in secs autovacuum_vacuum_threshold =3D 100 # min # of tuple updates before # vacuum autovacuum_analyze_threshold =3D 100 # min # of tuple updates before=20 # analyze autovacuum_vacuum_scale_factor =3D 0.1 # fraction of rel size before=20 # vacuum autovacuum_analyze_scale_factor =3D 0.1 # fraction of rel size before=20 # analyze autovacuum_vacuum_cost_delay =3D 100 # default vacuum cost delay for=20 # autovac, -1 means use=20 # vacuum_cost_delay autovacuum_vacuum_cost_limit =3D 100 # default vacuum cost limit for=20 # autovac, -1 means use # vacuum_cost_limit Any suggestions will be appreciated.