[opencms-dev] opencms6 - postgresql8 and performance

[Alexander Wallace]

Have you done vacum on postgresql to see if that changes your issues?

On Wednesday 14 September 2005 01:57 am, Bouchard Sylvie wrote:
> 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
>