I agree, MySQL is MUCH better with OTRS 2.2.2 on Open SUSE 10.2 I used PostgreSQL on the first installation and it was pretty slow. Switched to MySQL, (know it better anyway) and my little box is pretty fast. Christian Petrou│IT Department The Light Group││ 702.693.8300 x 7777│ 702.693.8310 ││ 702.217.6775 cell 6276 S. Rainbow Ste. 120 Las Vegas, NV 89118 6 LIGHTiT@lightlv.com │http://www.lightgroup.com Please consider the environment before printing this email  -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Andy Lubel Sent: Wednesday, September 19, 2007 1:25 PM To: User questions and discussions about OTRS.org Subject: Re: [otrs] What is more faster for otrs: MySQL or PostgreSQL Mysql hands down. On 9/19/07 3:33 PM, "Rodriguez Garcia, Jose Luis" wrote:

I am doing the installation of a otrs server on a Solaris box, and I will like to know what is the faster of these dabase servers for OTRS: MySQL or PostgreSQL.

Jose Luis Rodriguez

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/

Andy Lubel Application Administrator / IT Department GTSI Corp. 3901 Stonecroft Boulevard Chantilly, VA 20151 Tel: 1.800.999.GTSI ext.2309 Dir: 703.502.2309 Andy.Lubel@gtsi.com -- _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/

On Wed, 19 Sep 2007, Andy Lubel wrote:

Mysql hands down.

That's kind of an outdated piece of info. More recent benchmarks show them being very close, and postgres passing mysql for more complicated queries. And you have to have both configured on equal footing - postgres will not eat your data by default, mysql gets slow when you force data integrity. JMHO, of course. Browse the postgres-performance archives some time, it's good reading! Charles

On 9/19/07 3:33 PM, "Rodriguez Garcia, Jose Luis" wrote:

...

I am doing the installation of a otrs server on a Solaris box, and I will like to know what is the faster of these dabase servers for OTRS: MySQL or PostgreSQL.

Jose Luis Rodriguez

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/

Andy Lubel Application Administrator / IT Department

GTSI Corp. 3901 Stonecroft Boulevard Chantilly, VA 20151 Tel: 1.800.999.GTSI ext.2309 Dir: 703.502.2309 Andy.Lubel@gtsi.com

--

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/

On 9/25/07 10:56 AM, "Torsten Thau" wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Rodriguez Garcia, Jose Luis schrieb:

...

I am doing the installation of a otrs server on a Solaris box, and I will like to know what is the faster of these dabase servers for OTRS: MySQL or PostgreSQL.

...you may produce some flame war with this question ;-). Anyway, due to the many parameters, it's not possible to answer this question reliably. If data integrity is most important for you PostgreSQL should be the choice rather than MySQL.

http://sql-info.de/mysql/gotchas.html

Yes, there's a list for postgres too (but it's not that extensive)...

Look at the install base and the number of applications/users that use mysql rather than postgres. We chose mysql on the basis of community acceptance, we have seen mysql gain much more momentum in the marketplace than postgres. Personally, I have never used postgres but im sure its still good, it ultimately comes down to what you are comfortable with!

http://sql-info.de/postgresql/postgres-gotchas.html

Anyway, this report is very interesting and contains some numbers and facts:

http://tweakers.net/reviews/657/6

regards, Torsten Thau

- -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG+SGZvXo8m5PgoXQRAkO5AJ9sdgHucnIK8tArLP3R64CDrrM+6gCeMgKf 1IsOlnJ1bjqaglA78hHrhRM= =bwSZ -----END PGP SIGNATURE----- _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/

Andy Lubel Application Administrator / IT Department GTSI Corp. 3901 Stonecroft Boulevard Chantilly, VA 20151 Tel: 1.800.999.GTSI ext.2309 Dir: 703.502.2309 Andy.Lubel@gtsi.com --