Yes that is it Jacques, the script i was looking for to remove some of
the db space:
delete from product_search_constraint where date(created_stamp) <
date(current_timestamp - '7 days'::interval);
delete from product_search_result where date(created_stamp) <
date(current_timestamp - '7 days'::interval);
delete from cart_abandoned_line where date(created_stamp) <
date(current_timestamp - '7 days'::interval);
delete from server_hit_bin where date(created_stamp) < date(current_timestamp -
'7 days'::interval);
delete from server_hit where date(created_stamp) < date(current_timestamp - '7
days'::interval);
delete from party_data_source where date(created_stamp) <
date(current_timestamp - '7 days'::interval);
-- delete everything but the past 8 days for the visit table to avoid FK issues
on date boundaries
delete from visit where date(created_stamp) < date(current_timestamp - '8
days'::interval);
Regards,
Hans
On 07/23/2013 02:54 PM, Jacques Le Roux wrote:
It's somewhere there
http://web.archive.org/web/20070627120930/http://ofbizwiki.go-integral.com/Wiki.jsp?page=Main
I did not find it, maybe you can?
For those interested (by OFBiz history :) I let a link here
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Documentation+Index#OFBizDocumentationIndex-DocumentsonOtherSites
Jacques
----- Original Message -----
From: "Hans Bakker" <[email protected]>
To: <[email protected]>
Sent: Tuesday, July 23, 2013 4:54 AM
Subject: housekeeping of visitor and related files.
A few years ago there was a Postgresql script to delete the content
older than a week of the visitor and related files, original it was in:
http://ofbizwiki.go-integral.com/Wiki.jsp?page=Pg_monitoring
anybody still has a copy? I lost mine here......
Regards,Hans
