Re: MusicBrainz postgres performance issues

Поиск
Список
Период
Сортировка
От Joao Junior
Тема Re: MusicBrainz postgres performance issues
Дата
Msg-id CABnPa_jvyTczkQi0b5mq8N3b5HruZYuqi3qh1EX_8-LQZ+4wHQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: MusicBrainz postgres performance issues  (Robert Kaye <rob@musicbrainz.org>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Best VPS provider for running performant PostgreSQL database server