Re: phpBB2 slow on postgres vs mysql ?

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Dave Cramer <dave(at)fastcrypt(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: phpBB2 slow on postgres vs mysql ?
Date: 2003-03-05 00:15:04
Message-ID: Pine.LNX.4.33.0303041712480.2773-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 27 Feb 2003, Dave Cramer wrote:

> Anyone have any experience with this and why it is slow

Are you running the latest version of phpBB or an older one? I know that
at first it was a kinda "let's just get it running" when they supported
postgresql, but looking through their code, it certainly looks aware of
postgresql and it's transacational nature.

If the whole thing is slow, maybe you have a wholly untuned postgresql
database or a poor connection to it, or some other problem getting in the
way?

My little celeron running PHP4.2.x and hitting a remote postgresql 7.2.x
server seems quite peppy running it.

So, when you say slow, how slow do you mean, like 5 or 10 seconds between
mouse clicks for the screen to come up, or an extra second here or there?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2003-03-05 00:27:45 Re: two concurrency questions
Previous Message Tom Lane 2003-03-05 00:14:23 Re: [PATCHES] ALTER SEQUENCE