Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ron Johnson <ron.l.johnson@xxxxxxx> 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@xxxxxxxxxxx
p: 312.241.7800


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux