[opencms-dev] OpenCms in the future?

[Andreas Haumer]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!

(it looks like some threads got mixed up a little bit. This mail
should belong to the "opencms6 - postgresql8 and performance"
thread. I do reply to the mail from Gerard, though, so I can
better refer to his comments)

Lambert Gerard schrieb:
| Hello,
| thanks Andrea for the remarks and the tests.
| The purpose of the first version of script postgres was to map all index from the mysql database.
| I made the changes suggested and withdrawn index which seemed useless to me (on the keys and included in others index).
| Here a cleaned version.
|
The new script contains a syntax error in the
CREATE TABLE CMS_PROJECTS statement (comma at
the end of the last line)

There is also index IDX_BACKUP_PROPERTYDEF_2 which
does the same as line UNIQUE(PROPERTYDEF_NAME) in
the CREATE TABLE CMS_BACKUP_PROPERTYDEF statement.

| The order in the script is the same as in the mysql script
|
I noticed that the new script omits a fex indices the original
script for PostgreSQL creates. Did you remove them based on
the results of EXPLAIN for the relevant queries?

- - andreas

- --
Andreas Haumer                     | mailto:andreas at xss.co.at
*x Software + Systeme              | http://www.xss.co.at/
Karmarschgasse 51/2/20             | Tel: +43-1-6060114-0
A-1100 Vienna, Austria             | Fax: +43-1-6060114-71
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDLE5dxJmyeGcXPhERAq61AJ4oLWwsTeJUnly/dypvFEyHOpboNwCdFnQJ
BsdHhjXYo+ZI1rU+I21CVzY=
=9gtH
-----END PGP SIGNATURE-----