No subject

Sun Mar 31 09:34:23 UTC 2013

least 1 of these extensions is still installed, as the last write was by
the datastorer on the 4th September.

The package revision table is also quite large, but this is expected due to
the daily updating of all Eurostat packages. This should be regularly
cleared with the purge-package-extra-revision paster command as in previous
releases.

Regards,
John

--047d7b343ef2cd63f004e747ebc9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Bert,<div><br></div><div>I have had a look at the PO da=
tabase dump. The sizes of the largest tables are as follows:</div><div><br>=
</div><div><div>public.kombu_message =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 | 15 GB</div>

<div>pg_toast.pg_toast_78586 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0| 3662 MB</div><div>public.task_status =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 | 1548 MB</div><div>public.package_extra_revision =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| 811 MB</div><div>public.task_status_en=
tity_id_task_type_key_key | 670 MB</div>

<div>public.task_status_pkey =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0| 458 MB</div></div><div><br></div><div>Apart from package_extra_revisio=
n, the other large tables all refer to tables used by the old CKAN extensio=
ns (such as ckanext-archiver, ckanext-datastorer and ckanext-qa). These sho=
uld not be installed any more.</div>

<div><br></div><div>In the previous release, we supplied a paster command t=
o purge the task_status and kombu_message tables:</div><div><br></div><div>=
paster --plugin=3Dckanext-ecportal ecportal purge-task-data -c &lt;config&g=
t;<br>

</div><div><br></div><div>Running this should get rid of most of this unnec=
essary data (although you will probably to do a VACUUM in postgres afterwar=
ds to reclaim space). This should only have to be run once if the extension=
s have been correctly uninstalled. If these tables continue to grow, then a=
t least one of the extensions is still installed. So, make sure that none o=
f the following appear in the ckan.plugins config list: archiver, qa, datas=
torer.</div>

<div><br></div><div>From looking at the timestamps of the task_status entri=
es, it would seem at least 1 of these extensions is still installed, as the=
 last write was by the datastorer on the 4th September.</div><div><br>
</div>
<div>The package revision table is also quite large, but this is expected d=
ue to the daily updating of all Eurostat packages. This should be regularly=
 cleared with the purge-package-extra-revision paster command as in previou=
s releases.</div>

<div><br></div><div>Regards,</div><div>John</div></div>

--047d7b343ef2cd63f004e747ebc9--