housekeeping of visitor and related files.

[hans_bakker]

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

[Jacques Le Roux]

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" <[hidden email]>
To: <[hidden email]>
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
>
>
>

[hans_bakker]

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" <[hidden email]>
> To: <[hidden email]>
> 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
>>
>>
>>