From: | PFC <lists(at)peufeu(dot)com> |
---|---|
To: | "Louis-David Mitterrand" <vindex+lists-pgsql-general(at)apartia(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: typical schema for a forum? |
Date: | 2007-05-09 10:04:03 |
Message-ID: | op.tr10w1ljcigqcu@apollo13 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have written a little PHP+postgres forum for benchmarking purposes, to
see how fast postgres could go.
It has basic forum features, like forums (duh), topics, posting,
pagination, watching topics, topic & post count, display newest topic and
post in topic & forum pages, templates, topics pagination in O(1) not
O(number of pages), etc.
I also wrote a companion benchmark script which tortures the server with
HTTP requests, viewing and posting.
it answered my "how fast can it go" question : more than 500 dynamic
pages/second on a Core 2. Most of the load is PHP : postgres could handle
much, much more than this.
If people are interested in this as a benchmark, I can write some docs
(and make a MySQL version).
If you want to use it as a base for your forum, you're welcome.
Who wants the source ?
On Wed, 09 May 2007 10:49:17 +0200, Louis-David Mitterrand
<vindex+lists-pgsql-general(at)apartia(dot)org> wrote:
> Hi,
>
> I'm trying to implement a forum with mason and postgresql. What is the
> typical database schema of a forum (threaded or flat) application?
>
> Thanks,
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Smith | 2007-05-09 10:56:56 | Solaris Postgresql 8.1.8 vs Postgresql 8.2.4 |
Previous Message | Dimitri Fontaine | 2007-05-09 09:51:06 | Re: PG on Debian 4.0.x ? |