Is there temp information I could delete from the database periodically?

My database is reaching the 10.000 rows capacity for Heroku free database. That is kind of strange because I have only 10 users and 7 questions. Yesterday I had a massive number of visits, but only 1 new question.

I imagine that there are some logging rows or some kind of temporary information stored in the database to create this number of new rows. Is there something I could erase periodically to free space in the database?

Thanks, Oscar

It is a sessions table, it may bring problems with the disk space. Even if you delete the records, the space will not be released to the system.

A half-a$$ solution may be to drop the table and create it again, a better solution is to move sessions off the datadase.

13.2k

Evgeny

answered 12 years ago

link

Comments

Or use python manage.py cleanup (https://docs.djangoproject.com/en/1.3/ref/django-admin/#django-admin-cleanup)

Fitoria (12 years ago)

Actually I am concerned with row numbers. I will check the number of rows and delete them periodically :) Could you please give me the name of this table?

oscarfh (12 years ago)

it's called: django_session

Fitoria (12 years ago)

Thanks! I will try the cleanup command :)

oscarfh (12 years ago)

Running cleanup may not reduce the on-disk size of the table though. But if you run that command regularly - it will prevent or slow growth of the table. So now you might need to drop it and then implement the regular cleanup.

Evgeny (12 years ago)

see more comments

Is there temp information I could delete from the database periodically? savecancel

Comments

1 Answer

Comments

Is there temp information I could delete from the database periodically?