From: Federico Campoli <rotellaro@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Trouble with phpbb installation
Date: Tue, 2 May 2006 01:20:37 +0200
Message-ID: <a3e8e2210605011620j4cb28dbend17281b4c18cd464@mail.gmail.com> (raw)
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
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: rotellaro@gmail.com
Subject: Re: Trouble with phpbb installation
In-Reply-To: <a3e8e2210605011620j4cb28dbend17281b4c18cd464@mail.gmail.com>
References: <a3e8e2210605011620j4cb28dbend17281b4c18cd464@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox