[opencms-dev] opencms6 - postgresql8 and performance

[Alexander Kandzior]

Sylvie,

Thanks for this contribution.

You did change quite a lot of lines in the script (revealed by diff to the
current version). The old version was rather well tested and known to work
with PostgreSQL 7/8. 

Is there someone else using PostgeSQL who can confirm that the new script
also works as well as the old one?

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: Thursday, September 15, 2005 1:26 PM
> To: The OpenCms mailing list
> Subject: [opencms-dev] opencms6 - postgresql8 and performance
> 
> 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
>