X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3C5269FB1B9 for ; Mon, 1 May 2006 20:20:46 -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 79792-05 for ; Mon, 1 May 2006 20:20:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.201]) by postgresql.org (Postfix) with ESMTP id 385CA9FA2BE for ; Mon, 1 May 2006 20:20:39 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id o1so2469319nzf for ; Mon, 01 May 2006 16:20:37 -0700 (PDT) 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=PYXUHdZqkYVxeBIJHnGZd4CBJ2YsY6uDgQKqtjEEvmbvRUoA9fLd/5uMh1Il3uSN4y83dQlOQaztzQERS426BAnp5Mae6cSJQCjXCISXdzqiM9OXiBxAXzdXxy6QWLe8hms/bdEHlgnwWQ9XS6na43CMRyrTvSlaU/pE9YrxWLU= Received: by 10.36.129.3 with SMTP id b3mr118176nzd; Mon, 01 May 2006 16:20:37 -0700 (PDT) Received: by 10.36.105.8 with HTTP; Mon, 1 May 2006 16:20:37 -0700 (PDT) Message-ID: Date: Tue, 2 May 2006 01:20:37 +0200 From: "Federico Campoli" To: pgsql-admin@postgresql.org Subject: Trouble with phpbb installation MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/8 X-Sequence-Number: 21540 Hi. Yesterday I've migrated a PHPBB mysql database on a fresh install of postgresql 8.1.3 on a debian gnu/linux sarge 3.1. The python script that migrate schema and data worked fine and I got all data on the my postgresql database. But, when the number of phpbb connected users increase (about 70-80), postgresql go crazy. The number of postgres process increase too and not decrease when the php pages released the connection (I use not persistent connection on my php cofiguration). Changing the database parameter like checkpoint_timeout, write_mode=20 and shared_buffer has no effect on this strange situation. I've noticed also that when the connected user increase after 70 the data are not commited immediately. After a shutdown and restart of the postgresql instance I found into the tables the data inserted several minutes later. It seems like the commit has a huge delay to have effect on the DBMS. Please help me. Federico