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
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 |