[opencms-dev] opencms6 - postgresql8 and performance

[Bouchard Sylvie]

Hi,
Here the complete script of creation of the tables for PostgreSQL with the addition of the indices defined in script for MySQL. We tested it at the time of a new installation of opencms 
I hope that will be useful for you
Sorry for my bad english...
Sylvie

-----Message d'origine-----
De : opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org]De la part de Alexander Kandzior
Envoyé : mercredi, 14. septembre 2005 09:07
À : 'The OpenCms mailing list'
Objet : RE: [opencms-dev] opencms6 - postgresql8 and performance


Hi Sylvie,

please keep in mind that the PostgreSQL support has been contributed to the
distribution (the initial version was developed by Antonio Core). The driver
has been reported to work well, but I am not sure about the performance.

Should there be any optimizations, such as the additional indexes you
mention, please contribute these back to the OpenCms community so that we
can include these improvements in a futire distribution. 

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com

 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Bouchard Sylvie
> Sent: Wednesday, September 14, 2005 8:58 AM
> To: opencms-dev at opencms.org
> Subject: [opencms-dev] opencms6 - postgresql8 and performance
> 
> Good afternoon,
> We have an application based on opencms6 / Tomcat5. The data 
> management of the content is kept in a PostgreSQL 8.0.2 base.
> The pages' display is very slow (it can take up to several 
> minutes per refresh). Thus, it would not be applicable  in production.
> Material configuration details of the server hosting PostgreSQL :
> - Windows Server 2003
> - Bi-processor Intel Xeon 3.0 GHz
> - RAM 4 Go
> - Disks on SAN - access through optical fibre
> 
> I have noticed that several sequential accesses happen on the 
> tables of the cms during the questioning.
> We added the same index as those in scripts of MySQL. The 
> access method and times are better but still too slow
> 
> My questions :
> What would be the best configuration parameters of the 
> postgresql.conf file (or another file) to enhance the performances ?
> What could we do on Opencms' side to improve the data interrogation?
> Is the creation of the tables (index) through opencms optimum ?
> Your advices are most welcome.
> Sylvie
> 
> 
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list To 
> change your list options, or to unsubscribe from the list, 
> please visit http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
> 



_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev
-------------- next part --------------
A non-text attachment was scrubbed...
Name: new_create_tables_postgres.sql
Type: application/octet-stream
Size: 16938 bytes
Desc: new_create_tables_postgres.sql
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050915/ffa01669/attachment.obj>