Re: a heavy duty operation on an "unused" table kills my server
От
Greg Smith
Тема
Re: a heavy duty operation on an "unused" table kills my
server
Дата
Msg-id
4B51FB9E.4060207@2ndquadrant.com
Ответ на
Список
Дерево обсуждения
a heavy duty operation on an "unused" table kills my server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Craig James <craig_james@emolecules.com>
Re: a heavy duty operation on an "unused" table kills my
server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Craig Ringer <craig@postnewspapers.com.au>
Re: a heavy duty operation on an "unused" table kills my
server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Craig Ringer <craig@postnewspapers.com.au>
Re: a heavy duty operation on an "unused" table kills my
server Robert Haas <robertmhaas@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Greg Smith <greg@2ndquadrant.com>
Re: a heavy duty operation on an "unused" table kills my
server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Craig Ringer <craig@postnewspapers.com.au>
Re: a heavy duty operation on an "unused" table kills my
server Andy Colson <andy@squeakycode.net>
Re: a heavy duty operation on an "unused" table kills my
server Greg Smith <greg@2ndquadrant.com>
Re: a heavy duty operation on an "unused" table kills my
server Andy Colson <andy@squeakycode.net>
Re: a heavy duty operation on an "unused" table kills my
server Greg Smith <greg@2ndquadrant.com>
Re: a heavy duty operation on an "unused" table kills my
server Matthew Wakeling <matthew@flymine.org>
Re: a heavy duty operation on an "unused" table kills my
server Craig James <craig_james@emolecules.com>
Re: a heavy duty operation on an "unused" table kills my
server Matthew Wakeling <matthew@flymine.org>
Re: a heavy duty operation on an "unused" table kills my
server Greg Smith <greg@2ndquadrant.com>
Re: a heavy duty operation on an "unused" table kills my
server Matthew Wakeling <matthew@flymine.org>
Re: a heavy duty operation on an "unused" table kills my
server Greg Smith <greg@2ndquadrant.com>
Re: a heavy duty operation on an "unused" table kills my
server Matthew Wakeling <matthew@flymine.org>
Re: a heavy duty operation on an "unused" table kills my
server Greg Smith <greg@2ndquadrant.com>
Re: a heavy duty operation on an "unused" table kills my
server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Euler Taveira de Oliveira <euler@timbira.com>
Re: a heavy duty operation on an "unused" table kills my
server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Pierre Frédéric Caillaud<lists@peufeu.com>
Re: a heavy duty operation on an "unused" table kills my
server Craig Ringer <craig@postnewspapers.com.au>
Re: a heavy duty operation on an "unused" table kills my
server Scott Marlowe <scott.marlowe@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Eduardo Piombino <drakorg@gmail.com>
Re: a heavy duty operation on an "unused" table kills my
server Scott Marlowe <scott.marlowe@gmail.com>
Robert Haas wrote: > Seems like you'd also need to think about priority inversion, if the > "low-priority" backend is holding any locks. > Right, that's what I was alluding to in the last part: the non-obvious piece here is not how to decide when the backend should nap because it's done too much I/O, it's how to figure out when it's safe for it to do so without causing trouble for others. -- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.com
В списке pgsql-performance по дате отправления
От: Robert Haas
Дата:
От: Pierre Frédéric Caillaud
Дата:
