[opencms-dev] opencms6 - postgresql8 and performance

[Lambert Gerard]

Hello,
Sorry for the mix in the thread.
I send a updated version of the script.
These script is only based on the mysql script and not on a analysis of explain in postgres.
The base for this job was the remark from Sylvie :
[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 ]
Best Regards, 
Gérard

 <<create_tables_v2.sql>> 
Gérard Lambert
-------------------------------------------------------------------------------
esnig
Ecole Supérieure Neuchâteloise d'Informatique de Gestion
Maladière 84
CH-2000 Neuchâtel
-------------------------------------------------------------------------------
Ligne directe : ++41 (0) 32 717 4231
Secrétariat : ++41 (0) 32 717 4080
Fax : ++41 (0) 32 717 4089
-------------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: create_tables_v2.sql
Type: application/octet-stream
Size: 15552 bytes
Desc: create_tables_v2.sql
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050922/f33ceaec/attachment.obj>