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

Поиск
Список
Период
Сортировка
От Marc Cousin
Тема Re: Very big insert/join performance problem (bacula)
Дата
Msg-id 200907131651.11359.mcousin@sigma.fr
обсуждение исходный текст
Ответ на Re: Very big insert/join performance problem (bacula)  (SystemManagement <rdsys@fs.wettzell.de>)
Список 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 по дате отправления:

Предыдущее
От: SystemManagement
Дата:
Сообщение: Re: Very big insert/join performance problem (bacula)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Very big insert/join performance problem (bacula)