Re: increasing the default WAL segment size
От
Tom Lane
Тема
Re: increasing the default WAL segment size
Дата
Msg-id
1427.1472092429@sss.pgh.pa.us
Ответ на
increasing the default WAL segment size (Robert Haas)
Список
Дерево обсуждения
increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: increasing the default WAL segment size Tom Lane <tgl@sss.pgh.pa.us>
Re: increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: increasing the default WAL segment size Tom Lane <tgl@sss.pgh.pa.us>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Tom Lane <tgl@sss.pgh.pa.us>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: increasing the default WAL segment size Bruce Momjian <bruce@momjian.us>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Wolfgang Wilhelm <wolfgang20121964@yahoo.de>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Tom Lane <tgl@sss.pgh.pa.us>
Re: increasing the default WAL segment size Magnus Hagander <magnus@hagander.net>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Eduardo Morras <emorrasg@yahoo.es>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Prabhat Sahu <prabhat.sahu@enterprisedb.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Jeff Janes <jeff.janes@gmail.com>
Re: increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] increasing the default WAL segment size "David G. Johnston" <david.g.johnston@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: increasing the default WAL segment size Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: increasing the default WAL segment size Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: increasing the default WAL segment size Amit Kapila <amit.kapila16@gmail.com>
Re: increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size David Steele <david@pgmasters.net>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] increasing the default WAL segment size Beena Emerson <memissemerson@gmail.com>
Re: increasing the default WAL segment size Claudio Freire <klaussfreire@gmail.com>
Re: increasing the default WAL segment size Bruce Momjian <bruce@momjian.us>
Re: increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: increasing the default WAL segment size Stephen Frost <sfrost@snowman.net>
Re: increasing the default WAL segment size Peter Geoghegan <pg@heroku.com>
Re: increasing the default WAL segment size Simon Riggs <simon@2ndquadrant.com>
Re: increasing the default WAL segment size Bruce Momjian <bruce@momjian.us>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Amit Kapila <amit.kapila16@gmail.com>
Re: increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: increasing the default WAL segment size Amit Kapila <amit.kapila16@gmail.com>
Re: increasing the default WAL segment size Michael Paquier <michael.paquier@gmail.com>
Re: increasing the default WAL segment size Andres Freund <andres@anarazel.de>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Magnus Hagander <magnus@hagander.net>
Re: increasing the default WAL segment size Robert Haas <robertmhaas@gmail.com>
Re: increasing the default WAL segment size Claudio Freire <klaussfreire@gmail.com>
Robert Haas writes: > I'd like to propose that we increase the default WAL segment size, > which is currently 16MB. That seems like a reasonable thing to consider ... > Possibly it would make sense for this to be configurable at initdb > time instead of requiring a recompile; ... but I think this is just folly. You'd have to do major amounts of work to keep, eg, slave servers on the same page as the master about what the segment size is. Better to keep treating it like BLCKSZ, as a fixed parameter of a build. (There's a reason why we keep this number in pg_control.) regards, tom lane
В списке pgsql-hackers по дате отправления