On Thursday 14 June 2007 10:53:09 Marc Cousin wrote:
> There is nothing that will totally solve the performance problems you're
> facing... For now, bacula's code does many small operations, each in it's
> transaction, and postgresql isn't good at that...
> Removing indexes may help the insert spee
> An: [EMAIL PROTECTED]
> > Cc: bacula-users@lists.sourceforge.net
> > Betreff: Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL
> >
> > On Thursday 14 June 2007 08:36:19 Berner Martin wrote:
> > > Yes it is because I have some bottleneck with PostgreSQ
erformance?
> -Ursprungliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Auftrag von Marc
> Cousin
> Gesendet: Donnerstag, 14. Juni 2007 08:45
> An: [EMAIL PROTECTED]
> Cc: bacula-users@lists.sourceforge.net
> Betreff: Re: [Bacula-users] migrat
On Thursday 14 June 2007 08:36:19 Berner Martin wrote:
> Yes it is because I have some bottleneck with PostgreSQL as backend. So I
> try to give MySQL a try on a Testenvirement. But it has no sense if I cant
> migrate the catalogue. And to make a true comparison it is important to
> have as much en
13. Juni 2007 18:28
> An: bacula-users@lists.sourceforge.net; [EMAIL PROTECTED]
> Betreff: Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL
>
>
> On Wednesday 13 June 2007 10:18:44 Berner Martin wrote:
> > Hello
> > Dos someone have already do a migration of t
Marc Cousin wrote:
> On Wednesday 13 June 2007 10:18:44 Berner Martin wrote:
>> Hello
>> Dos someone have already do a migration of the Catalogue from a PostgreSQL
>> to y MySQL? Or know how it has to work? I tried to dump Postgres so that he
>> dump only the Data and use INSERT in stead of COPY. T
On Wednesday 13 June 2007 10:18:44 Berner Martin wrote:
> Hello
> Dos someone have already do a migration of the Catalogue from a PostgreSQL
> to y MySQL? Or know how it has to work? I tried to dump Postgres so that he
> dump only the Data and use INSERT in stead of COPY. Then I grep only the
> lin
Hello
Dos someone have already do a migration of the Catalogue from a PostgreSQL to y
MySQL? Or know how it has to work?
I tried to dump Postgres so that he dump only the Data and use INSERT in stead
of COPY. Then I grep only the lines with Inserts.
I create the bacula-tables with the script (mak