RE: Disk Groups/Storage Management for a Large Database in PostgreSQL

Поиск
Список
Период
Сортировка
От Scot Kreienkamp
Тема RE: Disk Groups/Storage Management for a Large Database in PostgreSQL
Дата
Msg-id DM6PR15MB3797537C789B024C0843AFDD9A742@DM6PR15MB3797.namprd15.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Disk Groups/Storage Management for a Large Database in PostgreSQL  (Amit Sharma <amitpgsql@gmail.com>)
Список pgsql-general

Thanks Olivier and Scot for your inputs!

 

Another data point I would like to share is that VMs will be built in Azure Cloud with Azure Managed Storage and Locally redundant storage (LRS) option with a remote DR as well. 

 

 LVM or ZFS would still be a good option to allow easy storage/disk management like add, resize or remove disks while PostgreSQL services are up? 

Is equal data distribution a challenge on LVM/ZFS disks?

 

 

Thanks

Amit

 

I would not call data distribution a challenge, but something to be aware of.  If LVM has 3 disks in a pool it will, by default, use all of disk 1, then use all of disk 2, then use all of disk 3.  The reason for that is with the default you can add new disks one at a time.  With striping you must add new disks equal to the number of stripes.  Either way I would still advise use of LVM. 

Scot Kreienkamp | Applications Infrastructure Architect | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | ( (734) 384-6403 | |  ) 1-734-915-1444  Email: Scot.Kreienkamp@la-z-boy.com

 

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by e-mail or by telephone at the above number. Thank you.

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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Need assistance for running postgresql procedures
Следующее
От: James Colannino
Дата:
Сообщение: Providers missing from pgdg-common for GDAL 3.7 (related to multiple missing providers from pgdg-common)