[Erp5-dev] How to make ERP5 work with PostgreSQL?

[Jean-Paul Smets]

Hi,
Please also note that pgSQL tests we did showed 10 times slower
performance for insert. So, it will work, but I doubt it will be that
fast for reindexing.
JPS.

bartek a écrit :
> Jean-Paul Smets wrote:
>   
>> Jacek Medrzycki a écrit :
>>     
>>> Duk Liu pisze:
>>>       
>>>> Hi all
>>>> I wanna make ERP5 work with PostgreSQL instead of MySQL.
>>>> Which module I should modify?
>>>> Is there any entry talk about it I should reference?
>>>> Is there anybody done it before?
>>>> I have to finish it before next week, can I?
>>>>
>>>>         
>>> I think You should make a Business Template similar to
>>> erp5_mysql_innodb_catalog, but working with psql.
>>>       
>> If someone made erp5_pgsql_catalog, it would be nice.
>>     
>>> As far as I know, there is no such bt in public repository. Correct me
>>> if I'm wrong.
>>>
>>>       
>> Some people decided to use PostgreSQL instead of MySQL but sadly, they
>> never contributed anything public.
>> Please note that when we measured PostgreSQL in the ERP5 context, we
>> found that inserts were nearly 10 times slower than MySQL inserts (maybe
>> in other contexts, PostgreSQL is better).
>>
>>     
>
> So, all it takes is a rewrite of all methods in portal_catalog so that 
> they comply with particularities of the Postgres syntax? Sounds ok. If 
> all the z-methods which are in the skins are ok then it seems quite 
> feasible.
>
> I have a prospect client who is a Postgres fanatic, and not using 
> postgresql is a deal-breaker, don't ask me why :)
>
> Bartek
>
>   
>> Regards,
>>
>> JPS.
>>     
>>> J.
>>> _______________________________________________
>>> Erp5-dev mailing list
>>> Erp5-dev at erp5.org
>>> http://erp5.org/mailman/listinfo/erp5-dev
>>>       
>> _______________________________________________
>> Erp5-dev mailing list
>> Erp5-dev at erp5.org
>> http://erp5.org/mailman/listinfo/erp5-dev
>>
>>     
>
>
>   


-- 
Jean-Paul Smets-Solanes, Nexedi CEO - Tel. +33(0)6 62 05 76 14
Nexedi: Consulting and Development of Libre / Open Source Software
http://www.nexedi.com
ERP5: Libre/ Open Source ERP Software for small and medium companies
http://www.erp5.org