Re: Very big insert/join performance problem (bacula)

From: Marc Cousin <mcousin(at)sigma(dot)fr>
To: dassing(at)fs(dot)wettzell(dot)de
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Very big insert/join performance problem (bacula)
Date: 2009-07-13 14:51:10
Message-ID: 200907131651.11359.mcousin@sigma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

We regularly do all of dbcheck. This is our real configuration, there are
really lots of servers and lots of files (500 million files backed up every
month).

But thanks for mentionning that.

The thing is we're trying to improve bacula with postgresql in order to make
it able to bear with this kind of volumes. So we are looking for things to
improve bacula and postgresql tuning to make it cope with the queries
mentionned (or rewrite the queries or the way to do inserts, that may not be
a problem either)

On Monday 13 July 2009 16:37:06 SystemManagement wrote:
> Hi,
> just a remark, as the number of entries seems to be very high:
> Did you ever activate bacula's program dbcheck Option 16?
>
> Regards
>
> Reiner

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2009-07-13 15:06:07 Re: Very big insert/join performance problem (bacula)
Previous Message SystemManagement 2009-07-13 14:37:06 Re: Very big insert/join performance problem (bacula)