Обсуждение: Archives / search

Guys,

I came across fudforum, in case you've never heard of it.

It is a discussion forum, but has support for mailing list
integration/syncronisation and can even send incoming posts, be that
from the lists or by online posts, to a newsgroup. (and can of course
syncronize with a newsgroup too)

It has a built in search engine, threaded tree views, and of course
supports PostgreSQL.

Might be worth going for this, as it is well maintained, and fairly easy
to set up / configure.

Supports themes too...

... John

> -----Original Message-----
> From: pgsql-www-owner@postgresql.org
> [mailto:pgsql-www-owner@postgresql.org] On Behalf Of John Hansen
> Sent: 30 September 2004 14:26
> To: pgsql-www@postgresql.org
> Subject: [pgsql-www] Archives / search
>
> It has a built in search engine, threaded tree views, and of
> course supports PostgreSQL.
>
> Might be worth going for this, as it is well maintained, and
> fairly easy to set up / configure.
>
> Supports themes too...

Cool - is this something you have the time/inclination to investigate
further?

Regards, Dave

>
> Cool - is this something you have the time/inclination to
> investigate further?
>

Yes, it's currently running on 220.244.191.249 & 220.244.191.250 but on
a vhost, so you need to set your proxy to one of those, or alternatively
add forum.postgresql.org A records to DNS.

pgsql-www only, and from today only....

Would need the mbox files to feed them to the forum :)

... John

John Hansen wrote:
<snip>
> Yes, it's currently running on 220.244.191.249 & 220.244.191.250 but on
> a vhost, so you need to set your proxy to one of those, or alternatively
> add forum.postgresql.org A records to DNS.

Let's get that done, see if it works nicely, then ask a wider audience
for feedback?

:)

Regards and best wishes,

Justin Clift

> pgsql-www only, and from today only....
>
> Would need the mbox files to feed them to the forum :)
>
> ... John
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

> >> 'k, first look and I know I wouldn't use it, so let's do it as an 'option'
> >> vs a 'replacement' ... thing is, we have realtime right now also, and that
> >> is the news groups, and, to be honest, I much prefer using a news reader
> >> to read a group then a forum ...

Second look, after importing just 1500 messages from -admin : search
sucks big time, even browsing takes forever. No, I don't think this will
work. I think i'll look for something else... :)

... John

John Hansen wrote:
>>>>'k, first look and I know I wouldn't use it, so let's do it as an 'option'
>>>>vs a 'replacement' ... thing is, we have realtime right now also, and that
>>>>is the news groups, and, to be honest, I much prefer using a news reader
>>>>to read a group then a forum ...
>
>
> Second look, after importing just 1500 messages from -admin : search
> sucks big time, even browsing takes forever. No, I don't think this will
> work. I think i'll look for something else... :)

Any chance that it's just badly optimised tables?  i.e. missing indexes
and such?

Regards and best wishes,

Justin Clift


> ... John
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

> Any chance that it's just badly optimised tables?  i.e. missing indexes
> and such?

I'll have a look, but I don't think so....


... John

>
> Any chance that it's just badly optimised tables?  i.e.
> missing indexes and such?
>

Indeed, removing the varchar(x) limitations, and reindexing the database
helped a lot.

... John