MySQL/ Postgres for Production??

[OfBizSuds]

Which is better MySQL or Postgres to use with Apache Ofbiz in Production? Are they both free to be used in production? Any performance issues faced with either one?

Any feedback will be appreciated.

Thanks,

Sudha

[Jacques Le Roux]

I'd prefer Postgres because of MySql Timestamp issue
Some like MySql because of it onboard replication feature.
Looks like Postgres 9.0 will have it also, soon...
http://markmail.org/message/zm72zkw6k55pyiqb

Jacques

From: "OfBizSuds" <[hidden email]>

> Which is better MySQL or Postgres to use with Apache Ofbiz in Production? Are
> they both free to be used in production? Any performance issues faced with
> either one?
>
> Any feedback will be appreciated.
>
> Thanks,
>
> Sudha
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/MySQL-Postgres-for-Production-tp2337949p2337949.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Matthieu Bollot-4]

Another thing that you may take care is that we still don't know the
future of mysql, since it's own by oracle…

--
Matthieu BOLLOT
www.nereide.biz

[BJ Freeman]

mysql seems to be the default of many providers, it is simpler to
install. it has some feature limitation like only 30 characters for
index. This is not a problems for small to medium companies.

Postgraduate has been around longer, and was originally designed to be
an enterprise commercial solution. It is open source.
Postgraduate generates a lot of files that take up memory


I have been using Postgraduate since 1996.

the key to performance is the indexing engine.


=========================
BJ Freeman  <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man

OfBizSuds sent the following on 8/25/2010 3:12 AM:

>
> Which is better MySQL or Postgres to use with Apache Ofbiz in Production? Are
> they both free to be used in production? Any performance issues faced with
> either one?
>
> Any feedback will be appreciated.
>
> Thanks,
>
> Sudha
>
>

[BJ Freeman]

Apologize spellchecker and fat fingers
Postgraduate =Postgresql

=========================
BJ Freeman  <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


BJ Freeman sent the following on 8/25/2010 5:36 AM:

> mysql seems to be the default of many providers, it is simpler to
> install. it has some feature limitation like only 30 characters for
> index. This is not a problems for small to medium companies.
>
> Postgraduate has been around longer, and was originally designed to be
> an enterprise commercial solution. It is open source.
> Postgraduate generates a lot of files that take up memory
>
>
> I have been using Postgraduate since 1996.
>
> the key to performance is the indexing engine.
>
>
> =========================
> BJ Freeman <http://bjfreeman.elance.com>
> Strategic Power Office with Supplier Automation
> <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat Y! messenger: bjfr33man
>
> OfBizSuds sent the following on 8/25/2010 3:12 AM:
>
>>
>> Which is better MySQL or Postgres to use with Apache Ofbiz in
>> Production? Are
>> they both free to be used in production? Any performance issues faced
>> with
>> either one?
>>
>> Any feedback will be appreciated.
>>
>> Thanks,
>>
>> Sudha
>>
>>
>

[Charles Tjandra]

Sorry, BJ.
Posgres ... is it? what you mean??

Thanks.

- Charles TJ

====

-----Original Message-----
From: BJ Freeman [mailto:[hidden email]]
Sent: 25 Agustus 2010 19:36
To: [hidden email]
Subject: Re: MySQL/ Postgres for Production??


mysql seems to be the default of many providers, it is simpler to
install. it has some feature limitation like only 30 characters for
index. This is not a problems for small to medium companies.

Postgraduate has been around longer, and was originally designed to be
an enterprise commercial solution. It is open source.
Postgraduate generates a lot of files that take up memory


I have been using Postgraduate since 1996.

the key to performance is the indexing engine.

[OfBizSuds]

Thanks.

Am I understanding correctly that "Postgres Plus Standard Server" is free to use in Production? For this, there will be no support from them correct? Has any of you used this with success?

Can MySQL Community Server also be used for free in production?

[BJ Freeman]

every Linux distribution is supported as far as I know.
In fact you can get real basic and just get the GNU Linux kernel and
start from there.
  both db have support as well.


=========================
BJ Freeman  <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


OfBizSuds sent the following on 8/25/2010 10:24 PM:
>
> Thanks.
>
> Am I understanding correctly that "Postgres Plus Standard Server" is free to
> use in Production? For this, there will be no support from them correct?
>
> Has any of you used this with success?