Re: [PERFORM] Postgres vs. MySQL

2004-11-25 Thread Dave Cramer
I did some work on RT wrt Postgres for a company and found that their was lots of room for improvement particularly if you are linking requests. The latest RT code hopefully has fixes as a result of this work. Dave Steinar H. Gunderson wrote: On Wed, Nov 24, 2004 at 09:57:52AM -0500, Christian

[PERFORM] Postgres backend using huge amounts of ram

2004-11-25 Thread Gary Doades
How much RAM can a single postgres backend use? I've just loaded a moderately sized dataset into postgres and was applying RI constraints to the tables (using pgadmin on windows). Part way though I noticed the (single) postgres backend had shot up to using 300+ MB of my RAM! The two tables are:

Re: [PERFORM] Postgres vs. DSpam

2004-11-25 Thread Andrew McMillan
On Wed, 2004-11-24 at 14:14 +0100, Evilio del Rio wrote: Hi, I have installed the dspam filter (http://www.nuclearelephant.com/projects/dspam) on our mail server (RedHat 7.3 Linux with sendmail 8.13 and procmail). I have ~300 users with a quite low traffic of 4000 messages/day. So it's a

Re: [PERFORM] Postgres vs. DSpam

2004-11-25 Thread Neil Conway
On Fri, 2004-11-26 at 14:37 +1300, Andrew McMillan wrote: In PostgreSQL the UPDATE will result internally in a new record being written, with the old record being marked as deleted. That old record won't be re-used until after a VACUUM has run, and this means that the on-disk tables will have