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 F

Re: [PERFORM] Postgres vs. MySQL

2004-11-24 Thread Steinar H. Gunderson
On Wed, Nov 24, 2004 at 02:14:18PM +0100, Evilio del Rio wrote: > 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. MySQL

2004-11-24 Thread Steinar H. Gunderson
On Wed, Nov 24, 2004 at 09:57:52AM -0500, Christian Fowler wrote: > As for performance, lots of others will probably volunteer tips and > techniques. In my experience, properly written and tuned applications will > show only minor speed differences. I have seen several open-source apps > that "s

Re: [PERFORM] Postgres vs. MySQL

2004-11-24 Thread Joshua D. Drake
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 quite common platform/environment, nothing sp

Re: [PERFORM] Postgres vs. MySQL

2004-11-24 Thread Christian Fowler
As for performance, lots of others will probably volunteer tips and techniques. In my experience, properly written and tuned applications will show only minor speed differences. I have seen several open-source apps that "support postgres" but are not well tested on it. Query optimization can ca

Re: [PERFORM] Postgres vs. MySQL

2004-11-24 Thread Richard Huxton
Evilio del Rio wrote: Please, could anyone explain me this difference? Is Postgres that bad? Is MySQL that good? Am I the only one to have observed this behavior? Do you have any record of configuration, system hardware, usage patterns, queries executed? If you can tell us what you tried (and why

Re: [PERFORM] Postgres vs. MySQL

2004-11-24 Thread Steinar H. Gunderson
On Wed, Nov 24, 2004 at 02:14:18PM +0100, Evilio del Rio wrote: > It's incredible! the same servers, the same messages, the same dspam > compilation (well each one with the corresponding > --with-storage-driver=*sql_drv). Postgres is getting worst than > 30s/message and MySQL process the same in le

[PERFORM] Postgres vs. MySQL

2004-11-24 Thread Evilio del Rio
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 quite common platform/environment, nothing spectacular. First ti