Обсуждение: Re: [GENERAL] Up to date conventional wisdom re max shared_buffersize?
On 09/19/2017 05:00 PM, Jerry Sievers wrote: [snip] > The DB is 10TB total size with OLTP plus some occasional heavy batching > which frequently correlates with degradation that requires intervention. > > Unrelated server problem forced us to relocate from a Debian/Wheezy 3.x > kernel 1T 144 CPU to the even bigger box mentioned earlier. And we wen > up a major kernel version also in the process. How did you backup/restore a 10TB db? -- World Peace Through Nuclear Pacification -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Ron Johnson <ron.l.johnson@cox.net> writes: > On 09/19/2017 05:00 PM, Jerry Sievers wrote: > [snip] > >> The DB is 10TB total size with OLTP plus some occasional heavy batching >> which frequently correlates with degradation that requires intervention. >> >> Unrelated server problem forced us to relocate from a Debian/Wheezy 3.x >> kernel 1T 144 CPU to the even bigger box mentioned earlier. And we wen >> up a major kernel version also in the process. > > How did you backup/restore a 10TB db? We just relocated the SAN volume. Takes about 1 minute :-) > > -- > World Peace Through Nuclear Pacification -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
On 09/20/2017 01:05 PM, Jerry Sievers wrote: > Ron Johnson <ron.l.johnson@cox.net> writes: > >> On 09/19/2017 05:00 PM, Jerry Sievers wrote: >> [snip] >> >>> The DB is 10TB total size with OLTP plus some occasional heavy batching >>> which frequently correlates with degradation that requires intervention. >>> >>> Unrelated server problem forced us to relocate from a Debian/Wheezy 3.x >>> kernel 1T 144 CPU to the even bigger box mentioned earlier. And we wen >>> up a major kernel version also in the process. >> How did you backup/restore a 10TB db? > We just relocated the SAN volume. Takes about 1 minute :-) Ah, yes. Major *kernel* version. Never mind... :) -- World Peace Through Nuclear Pacification -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general