Re: MusicBrainz postgres performance issues
От
Roxanne Reid-Bennett
Тема
Re: MusicBrainz postgres performance issues
Дата
Msg-id
55063EBC.5020405@tara-lu.com
Ответ на
MusicBrainz postgres performance issues (Robert Kaye)
Список
Дерево обсуждения
MusicBrainz postgres performance issues Robert Kaye <rob@musicbrainz.org>
Re: MusicBrainz postgres performance issues Andreas Kretschmer <akretschmer@spamfence.net>
Re: MusicBrainz postgres performance issues Robert Kaye <rob@musicbrainz.org>
Re: MusicBrainz postgres performance issues Andres Freund <andres@2ndquadrant.com>
Re: MusicBrainz postgres performance issues "Joshua D. Drake" <jd@commandprompt.com>
Re: MusicBrainz postgres performance issues Rural Hunter <ruralhunter@gmail.com>
Re: MusicBrainz postgres performance issues Roxanne Reid-Bennett <rox@tara-lu.com>
Re: MusicBrainz postgres performance issues Robert Kaye <rob@musicbrainz.org>
Re: MusicBrainz postgres performance issues Andreas Kretschmer <akretschmer@spamfence.net>
Re: MusicBrainz postgres performance issues Scott Marlowe <scott.marlowe@gmail.com>
Re: MusicBrainz postgres performance issues Thomas Kellerer <spam_eater@gmx.net>
Re: MusicBrainz postgres performance issues Robert Kaye <rob@musicbrainz.org>
Re: MusicBrainz postgres performance issues Joao Junior <jcoj2006@gmail.com>
Re: MusicBrainz postgres performance issues Josh Krupka <jkrupka@gmail.com>
Re: MusicBrainz postgres performance issues Robert Kaye <rob@musicbrainz.org>
Re: MusicBrainz postgres performance issues Andres Freund <andres@2ndquadrant.com>
Re: MusicBrainz postgres performance issues Scott Marlowe <scott.marlowe@gmail.com>
Re: MusicBrainz postgres performance issues "Joshua D. Drake" <jd@commandprompt.com>
Re: MusicBrainz postgres performance issues Scott Marlowe <scott.marlowe@gmail.com>
Re: MusicBrainz postgres performance issues Andres Freund <andres@2ndquadrant.com>
Re: MusicBrainz postgres performance issues Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
Re: MusicBrainz postgres performance issues Andres Freund <andres@2ndquadrant.com>
Re: MusicBrainz postgres performance issues Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
Re: MusicBrainz postgres performance issues Andres Freund <andres@2ndquadrant.com>
Re: MusicBrainz postgres performance issues Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: MusicBrainz postgres performance issues Scott Marlowe <scott.marlowe@gmail.com>
Re: MusicBrainz postgres performance issues Andres Freund <andres@2ndquadrant.com>
Re: MusicBrainz postgres performance issues "michael@sqlexec.com" <michael@sqlexec.com>
Re: MusicBrainz postgres performance issues Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: MusicBrainz postgres performance issues "michael@sqlexec.com" <michael@sqlexec.com>
Re: MusicBrainz postgres performance issues Andres Freund <andres@2ndquadrant.com>
Re: MusicBrainz postgres performance issues Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: MusicBrainz postgres performance issues "michael@sqlexec.com" <michael@sqlexec.com>
Re: MusicBrainz postgres performance issues Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: MusicBrainz postgres performance issues Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: MusicBrainz postgres performance issues Scott Marlowe <scott.marlowe@gmail.com>
Re: MusicBrainz postgres performance issues Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: MusicBrainz postgres performance issues Josh Krupka <jkrupka@gmail.com>
Re: MusicBrainz postgres performance issues Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
Re: MusicBrainz postgres performance issues Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
On 3/15/2015 6:54 AM, Robert Kaye wrote:
Hi!Robert,We at MusicBrainz have been having trouble with our Postgres install for the past few days. I’ve collected all the relevant information here:If anyone could provide tips, suggestions or other relevant advice for what to poke at next, we would love it.
Wow - You've engaged the wizards indeed.
I haven't heard or seen anything that would answer my *second* question if faced with this (my first would have been "what changed")....
What is the database actually trying to do when it spikes? e.g. what queries are running ?
Is there any pattern in the specific activity (exactly the same query, or same query different data, or even just same tables, and/or same users, same apps) when it spikes?
I know from experience that well behaved queries can stop being well behaved if underlying data changes
and for the experts... what would a corrupt index do to memory usage?
Roxanne
В списке pgsql-performance по дате отправления
От: Some Developer
Дата:
