You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@manifoldcf.apache.org by Marcello Lorenzi <ml...@sorint.it> on 2013/11/07 17:17:11 UTC

repohistory table on PostgresQL too high size

Hi All,
during the Manifold installation on our pre-production environment, we 
have noticed that the repohistory table on PostgresQL instance has ha 
size of 4 GB after few months of crawling.

Is it possible to remove some historical data from this table?

Thanks,
Marcello

Re: repohistory table on PostgresQL too high size

Posted by Ronny Heylen <se...@gmail.com>.

Should we delete it "manually" (direct SQL to PostgresQL) or using the UI?
Where in the UI?
Thanks,


On Thu, Nov 7, 2013 at 5:31 PM, Karl Wright <da...@gmail.com> wrote:

> Hi Marcello,
>
> The only thing in this table is the history data, so yes, feel free to
> delete as much of it as you want.
>
> Karl
>
>
>
> On Thu, Nov 7, 2013 at 11:17 AM, Marcello Lorenzi <ml...@sorint.it>wrote:
>
>> Hi All,
>> during the Manifold installation on our pre-production environment, we
>> have noticed that the repohistory table on PostgresQL instance has ha size
>> of 4 GB after few months of crawling.
>>
>> Is it possible to remove some historical data from this table?
>>
>> Thanks,
>> Marcello
>>
>>
>>
>>
>

Re: repohistory table on PostgresQL too high size

Posted by Karl Wright <da...@gmail.com>.

Hi Marcello,

The only thing in this table is the history data, so yes, feel free to
delete as much of it as you want.

Karl

On Thu, Nov 7, 2013 at 11:17 AM, Marcello Lorenzi <ml...@sorint.it>wrote:

> Hi All,
> during the Manifold installation on our pre-production environment, we
> have noticed that the repohistory table on PostgresQL instance has ha size
> of 4 GB after few months of crawling.
>
> Is it possible to remove some historical data from this table?
>
> Thanks,
> Marcello
>
>
>
>