Re: [GENERAL] Up to date conventional wisdom re max shared_buffer size?

Поиск
Список
Период
Сортировка
От Jerry Sievers
Тема Re: [GENERAL] Up to date conventional wisdom re max shared_buffer size?
Дата
Msg-id 87wp4tw8i6.fsf@jsievers.enova.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Up to date conventional wisdom re max shared_buffersize?  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Delrue
Дата:
Сообщение: Re: [GENERAL] libpq confusion
Следующее
От: Jerry Sievers
Дата:
Сообщение: [GENERAL] Any known issues Pg 9.3 on Ubuntu Xenial kernel 4.4.0?