Re: Very big insert/join performance problem (bacula) - Mailing list pgsql-performance

From Marc Cousin
Subject Re: Very big insert/join performance problem (bacula)
Date
Msg-id 200907131651.11359.mcousin@sigma.fr
Whole thread Raw
In response to Re: Very big insert/join performance problem (bacula)  (SystemManagement <rdsys@fs.wettzell.de>)
List 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

pgsql-performance by date:

Previous
From: SystemManagement
Date:
Subject: Re: Very big insert/join performance problem (bacula)
Next
From: Andres Freund
Date:
Subject: Re: Very big insert/join performance problem (bacula)