Revisão do banco de dados do site

[rougeth]

Estamos usando o plano Basic do Postgres no Heroku que custa 9 dólares por mês. Não podemos migrar para o plano Mini por causa da quantidade de dados no banco: 22534 linhas salvas, limite de 10k no plano mini.

[rougeth]

Lista das tables no banco e seus tamanhos

SELECT relname as "Tabela", reltuples as "Itens"
FROM pg_class
WHERE relkind = 'r' AND relname NOT LIKE 'pg_%'
ORDER BY relname;

+----------------------------+--------+
| Tabela                     | Itens  |
|----------------------------+--------|
| auth_group                 | 0.0    |
| auth_group_permissions     | 0.0    |
| auth_permission            | 60.0   |
| auth_user                  | 1938.0 |
| auth_user_groups           | 0.0    |
| auth_user_user_permissions | 0.0    |
| core_testdefaultfields     | 0.0    |
| django_admin_log           | 3.0    |
| django_content_type        | 20.0   |
| django_flatpage            | 1.0    |
| django_flatpage_sites      | 1.0    |
| django_migrations          | 37.0   |
| django_session             | 5638.0 |
| django_site                | 1.0    |
| members_category           | 2.0    |
| members_city               | 0.0    |
| members_member             | 1456.0 |
| members_organization       | 731.0  |
| municipios_municipio       | 5384.0 |
| municipios_uf              | 27.0   |
| payment_payment            | 2941.0 |
| payment_paymenttype        | 2.0    |
| payment_transaction        | 4282.0 |
| south_migrationhistory     | 10.0   |
| sql_features               | 713.0  |
| sql_implementation_info    | 12.0   |
| sql_parts                  | 10.0   |
| sql_sizing                 | 23.0   |
| thumbnail_kvstore          | 0.0    |
+----------------------------+--------+