Trouble with phpbb installation

From: "Federico Campoli" <rotellaro(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Trouble with phpbb installation
Date: 2006-05-01 23:20:37
Message-ID: a3e8e2210605011620j4cb28dbend17281b4c18cd464@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2006-05-02 00:48:05 Re: FW: Setting up of PITR system.
Previous Message bfraci 2006-05-01 22:25:49 Can we adjust postgres logging to also dump the bind variable data when an error occurs