Did you try 'vacuum full'?
Karl
On Fri, Jan 25, 2019 at 3:47 AM Bisonti Mario
wrote:
> Hallo.
>
> I use MCF 2.12 and postgresql 9.3.25 Solr 7.6 Tika 1.19 on Ubuntu Server
> 18.04
>
>
>
> Weekly I scheduled by crontab for the user postgres :
>
> 15 8 * * Sun vacuumdb --all --analyze
>
> 20 10 * * Sun reindexdb postgres
>
> 25 10 * * Sun reindexdb dbname
>
>
>
> I see that the job that indexes 70 documents daily, runs slower day by
> day.
>
> It run 8 hours a few of week ago, but now it runs in 12 hours and the
> number of documents are not changed too much.
>
>
>
> What could I do to speed up the job?
>
>
>
> Thanks a lot
>
> Mario
>
>