On Tue, Nov 7, 2017 at 7:41 PM, Nicolas MARTIN wrote:
> Here you are
>
> $ psql -c "EXPLAIN DELETE FROM session WHERE authenticated=0 AND
> last_visit<1504216800;"
> QUERY PLAN
>
Here you are
$ psql -c "EXPLAIN DELETE FROM session WHERE authenticated=0 AND
last_visit<1504216800;"
QUERY PLAN
-
Delete on session (cost=0.00..931.79 rows=1506 width=6)
-> Seq Scan on
On Tue, Nov 7, 2017 at 2:52 AM, Nicolas MARTIN wrote:
> $ time trac-admin ~/trac/ session purge "09/01/17 00:00:00"
> 18:34:31 Trac[env] INFO: environment
> startup [Trac 1.0.1]
> ...
> 18:34:32 Trac[util]
Finally I cut by three the number of remaining anonymous sessions (~10
000) in order to get a workable running time, by this I hope to improve
the overall behavior of Trac.
I set '1 month ago' in trac-admin purge argument and insert the command
in the cron.
Maybe it won't stay that way in the
Back to this thread, I launched a anonymous sessions purge with your
recommended options:
$ psql -c "SELECT COUNT(*) FROM session;"
count
---
32107
$ time trac-admin ~/trac/ session purge "01/01/15 00:00:00"
17:43:22 Trac[env] INFO: environment startup
On Wednesday, October 11, 2017 at 3:33:23 AM UTC-7, Nicolas MARTIN wrote:
>
> There was no surprise regarding the number of sessions removed (almost
> zero), the site has been released publicly a few months ago.
> My command was just for testing purpose but I didn't expect it would take
>
There was no surprise regarding the number of sessions removed (almost
zero), the site has been released publicly a few months ago.
My command was just for testing purpose but I didn't expect it would
take some much time with no substantial operations on the db.
In fact, we have a mean of 500
On Tuesday, October 10, 2017 at 1:49:30 PM UTC-7, Nicolas MARTIN wrote:
>
> Well finally the system completed the command (almost 8 minutes)
>
> '
>
> 22:35:40 Trac[tracdb] DEBUG: "FormDBComponent" does not need a schema
> upgrade.
>
> real8m25.808s
> user0m0.850s
> sys0m0.080s
>
>
Well finally the system completed the command (almost 8 minutes)
'
22:35:40 Trac[tracdb] DEBUG: "FormDBComponent" does not need a schema
upgrade.
real 8m25.808s
user 0m0.850s
sys 0m0.080s
'
The funny thing is that it has removed almost none sessions during that
time :-/
On
That's the first time I look into this, there is about ~63 000 sessions
in the database (PostgreSQL).
For the availability of the platform, it is kind of the right time
because we are well out of working hours here.
For my first attempts, don't know exactly the time I let but it is a
matter
10 matches
Mail list logo