On jeu, 2008-01-17 at 21:25 +0100, Ivan Sergio Borgonovo wrote:
Joshua posted the link to Edison's project that can support pg, MS
SQL, Oracle, DB2(?)... but well I had the feeling that Edison is a bit
ostracised. While I wouldn't define his work a DB AL... well it works
so kudos!
We have a very busy setup using multiple clusters, slony, etc. My problem
relates to the number of postgres procs increasing, and not decreasing
when idle. I eventually end up with thousands of idle processes listening
on /tmp/.s.PGSQL.5432 and not quitting (eventually bumping into
Dear friends,
I am reviewing some of PhpBB 3.x queries.
This allows me to learn more about PostgreSQL.
The thread can be read here:
http://area51.phpbb.com/phpBB/viewtopic.php?f=3t=29260
Do not hesitate to post your review there.
In pg_tables, I saw that there was an extensive use of
Dear Friends,
I am running a phpBB forum with more than 400.000 messages.
I would like to make sure that all indexes fit in shared memory.
How can I calculate the needed space of all indexes?
I remember this was part of VACUUM FULL ANALYSE or the like.
Kind regards,
Jean-Michel
Dear Friends,
My PhpBB forum with 4000 users was hacked in Switzerland.
Enquirers (not my own idea) proposed that I look for certain IPs in my
PostgreSQL 8.2 database. The problem is that PhpBB stored IPs as
strings, which seem to be more or less encoded.
In PhpBB, IPs are stored as Hexa:
Le samedi 10 mars 2007 à 08:32 +0300, Oleg Bartunov a écrit :
btw, we're working on new FTS feature of PostgreSQL, it's basically
tsearch integrated into the pg core. But it has some new features and
new SQL commands for configuring of FTS, so if the matter is not
pressing I'd recommend
to
Le vendredi 09 mars 2007 à 10:58 +0100, Magnus Hagander a écrit :
No idea. Assuming you want to do it beforehand. otherwise, just create
the index and see how large it got?
Thank you for your comments. I will add TSeach2 support to phpBB 3.x
soon.
I had incredible response time on simple
Dear Friends,
I am very impressed by TSearch2 and would like to thank Oleg and the
team for their hard work.
I would like to migrate a phpBB forum with more that 200.000 messages to
TSeach. Full text searches have become a bottleneck. When there are more
than 200 users, the server slow