Re: LVM and Postgres

Rory Campbell-Lange wrote:
> The server has a 250GB RAID10 (LSI 320-I + BBU) volume which I am
> thinking of slicing up in the following way (Linux 2.6 kernel):
>
>     /         : ext3  :  47GB (root, home etc)
>     /boot     : ext3  :  1GB
>     /tmp      : ext2  :  2GB
>     /usr      : ext3  :  4GB
>     /var      : ext3  :  6GB
>     -----------------------
>                         60GB
>
>     VG        :        190GB approx
>     -----------------------
>     Initially divided so:
>     /data     : ext3  : 90GB
>     /postgres : xfs   : 40GB
>
> This gives me left over space of roughly 60GB to extend into on the
> volume group, which I can balance between the /data and /postgres
> logical volumes as needed.
>
> Are there any major pitfalls to this approach?
>
> Thanks,
> Rory
>

It looks like you are using fast disks and xfs for filesystem on the
/postgresql partition. That's nice.

How many disks in the array?

One thing you miss is sticking a bunch of sequential log writes on a
separate spindle as far as I can see with this? WAL / XFS (i think) both
have this pattern. If you've got a fast disk and can do BBU write
caching your WAL writes will hustle.

Others can probably speak a bit better on any potential speedups.

- August