| cdo_commit_infos table cleanup [message #1859709] |
Fri, 23 June 2023 04:55  |
 I S
Messages: 13
Registered: May 2022 |
Junior Member |
|
|
Hi,
I have a cdo_commit_infos table which is too big, it has about 40 000 000 records. When I start my application, I see the following query in psql which is executing for a few minutes:
SELECT commit_time, branch_id, user_id, comment FROM cdo_commit_infos;
I have two questions:
1. What is the purpose of the cdo_commit_infos table?
2. Can I clean up the table using delete from cdo_commit_infos where user_id is null;
This query leaves a single record in the table which has "<initialize root resource>" comment and my application starts without delays but I'm not sure about long-term consequences of this.
The version of CDO I'm currently using is 3.0.1, at this moment I can't upgrade it to the latest one.
Also, I don't use any custom commit info handlers.
Thanks!
[Updated on: Fri, 23 June 2023 05:01] Report message to a moderator |
|
|
| Re: cdo_commit_infos table cleanup [message #1859710 is a reply to message #1859709] |
Fri, 23 June 2023 05:37  |
|
CDO 3.0.1 is 13 years old. I'm not sure how it will behave without this table or with an empty commit info table. Possible that this old CDO version does not even start without this table, or that it complains when you start using certain functions such as the History view or others.
In newer 4.x versions you can prevent this table from being created at server start by adding this to your cdo-server.xml:
<property name="commitInfoStorage" value="NO"/>
But even here it mostly depends on what functions of CDO you'll be using.
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03783 seconds
] 
Search
Help
Register
Login
Home
