Felix Knecht wrote:
I'm afraid most people use either MySQL, Oracle or MS SQL Server. I
know of no case in which Hippo CMS with Postgresql is used in
production. So I cannot help you.
Anyone else have experience with Postgresql?
No, but maybe you can get something out of the log files of
postgresql. When there are actions from the Hippo CMS you should see
them, ev. you want/need to set log level of postgresql to debug..
I just enabled the dump of the statements on postgresql.
It seems that the high CPU usage is caused by the quartz scheduler.
In my logfile i have a continuos flow of these statements:
--------------------------------------
LOG: statement: PREPARE <unnamed> AS SELECT 1 FROM QRTZ_LOCKS
LOG: statement: <BIND>
LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT 1 FROM QRTZ_LOCKS]
LOG: statement: <BIND>
LOG: statement: EXECUTE <unnamed> [PREPARE: BEGIN]
LOG: statement: PREPARE <unnamed> AS SELECT * FROM QRTZ_SCHEDULER_STATE
LOG: statement: <BIND>
LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT * FROM
QRTZ_SCHEDULER_STATE]
LOG: statement: PREPARE <unnamed> AS UPDATE QRTZ_SCHEDULER_STATE SET
LAST_CHECKIN_TIME = $1, RECOVERER = $2 WHERE INSTANCE_NAME = $3
LOG: statement: <BIND>
LOG: statement: EXECUTE <unnamed> [PREPARE: UPDATE
QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = $1, RECOVERER = $2 WHERE
INSTANCE_NAME = $3]
LOG: statement: <BIND>
LOG: statement: EXECUTE <unnamed> [PREPARE: COMMIT]
-----------------------------------------------------------
I don't need this frenetic checking.. it could be every minute without
any problem.
Can anyone tell me where i can change the interval between one quartz
check and the next one?
By MCM.
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
