Re: MusicBrainz postgres performance issues

Robert many thanks for feedback!!

Could you post your new pgbouncer config file??

How many postgresql process do you have now at OS with this new conf??

How many clients from app server hit your pgbouncer??

Regards,

Regards,

2015-03-16 11:32 GMT-03:00 Robert Kaye <rob(at)musicbrainz(dot)org>:

>
> > On Mar 16, 2015, at 2:22 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> >
> > I think it would be nice if you can amend your blog posting to include
> the solution that you found.
> >
> > Otherwise this will simply stick around as yet another unsolved
> performance problem
>
>
> Good thinking:
>
> http://blog.musicbrainz.org/2015/03/16/postgres-troubles-resolved/
>
> I’ve also updated the original post with the like to the above. Case
> closed. :)
>
> --
>
> --ruaok
>
> Robert Kaye -- rob(at)musicbrainz(dot)org --
> http://musicbrainz.org
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>