Re: [PERFORM] Filesystem and Disk Partitioning for New Server Setup

2016-02-24 Thread Wes Vaske (wvaske)
FYI, If your volume for pg data is the last partition, you can always add drives to the Dell PERC RAID group, extend the volume, then extend the partition and extend the filesystem. All of this can also be done live. Wes Vaske From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-perfor

Re: [PERFORM] Filesystem and Disk Partitioning for New Server Setup

2016-02-24 Thread Rick Otten
An LVM gives you more options. Without an LVM you would add a disk to the system, create a tablespace, and then move some of your tables over to the new disk. Or, you'd take a full backup, rebuild your file system, and then restore from backup onto the newer, larger disk configuration. Or you'd

Re: [PERFORM] Filesystem and Disk Partitioning for New Server Setup

2016-02-24 Thread Dave Stibrany
Thanks for the advice, Rick. I have an 8 disk chassis, so possible extension paths down the line are adding raid1 for WALs, adding another RAID10, or creating a 8 disk RAID10. Would LVM make this type of addition easier? On Wed, Feb 24, 2016 at 6:08 AM, Rick Otten wrote: > > 1) I'd go with xfs

Fwd: [PERFORM] Filesystem and Disk Partitioning for New Server Setup

2016-02-24 Thread Rick Otten
1) I'd go with xfs. zfs might be a good alternative, but the last time I tried it, it was really unstable (on Linux). I may have gotten a lot better, but xfs is a safe bet and well understood. 2) An LVM is just an extra couple of commands. These days that is not a lot of complexity given what y

Fwd: [PERFORM] Cloud versus buying my own iron

2016-02-24 Thread Rick Otten
Having gotten used to using cloud servers over the past few years, but been a server hugger for more than 20 before that, I have to say the cloud offers a number of huge advantages that would make me seriously question whether there are very many good reasons to go back to using local iron at all.

Re: [PERFORM] Cloud versus buying my own iron

2016-02-24 Thread Gunnar "Nick" Bluth
Am 24.02.2016 um 06:06 schrieb Craig James: > At some point in the next year we're going to reconsider our hosting > environment, currently consisting of several medium-sized servers (2x4 > CPUs, 48GB RAM, 12-disk RAID system with 8 in RAID 10 and 2 in RAID 1 > for WAL). We use barman to keep a hot