Postgres Pro
Downloads
Home   >   mailing lists

Re: MusicBrainz postgres performance issues - Mailing list pgsql-performance

From Joao Junior
Subject Re: MusicBrainz postgres performance issues
Date
Msg-id CABnPa_jvyTczkQi0b5mq8N3b5HruZYuqi3qh1EX_8-LQZ+4wHQ@mail.gmail.com
Whole thread Raw
In response to Re: MusicBrainz postgres performance issues  (Robert Kaye <rob@musicbrainz.org>)
List pgsql-performance
Tree view
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@musicbrainz.org>:

> On Mar 16, 2015, at 2:22 PM, Thomas Kellerer <spam_eater@gmx.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@musicbrainz.org     --    http://musicbrainz.org



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
Next
From: Jim Nasby
Date:
Subject: Re: Best VPS provider for running performant PostgreSQL database server