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 <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 по дате отправления
От: Gerdan Santos
Дата:
Сообщение: Re: \timing interval
От: Gerdan Santos
Дата:
Сообщение: Re: \timing interval
FAQ