Re: Recommended settings for PostgreSQL

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

 



Another option is to let PosgreSQL do the replication with local storage. There are great reasons for Ceph, but databases optimize for this kind of thing extremely well. 

With replication in hand, run snapshots to RADOS buckets for long term storage.

> On Oct 17, 2020, at 7:28 AM, Gencer W. Genç <gencer@xxxxxxxxxxxxx> wrote:
> 
> Hi,
> 
> I have an existing few RBDs. I would like to create a new RBD Image for PostgreSQL. Do you have any suggestions for such use cases? For example;
> 
> Currently defaults are:
> 
> Object size (4MB) and Stripe Unit (None)
> Features: Deep flatten + Layering + Exclusive Lock + Object Map + FastDiff
> 
> Should I use as is or should I use 16KB of object size and different sets of features for PostgreSQL?
> 
> Thanks,
> Gencer.
> _______________________________________________
> ceph-users mailing list -- ceph-users@xxxxxxx
> To unsubscribe send an email to ceph-users-leave@xxxxxxx
_______________________________________________
ceph-users mailing list -- ceph-users@xxxxxxx
To unsubscribe send an email to ceph-users-leave@xxxxxxx




[Index of Archives]     [Information on CEPH]     [Linux Filesystem Development]     [Ceph Development]     [Ceph Large]     [Ceph Dev]     [Linux USB Development]     [Video for Linux]     [Linux Audio Users]     [Yosemite News]     [Linux Kernel]     [Linux SCSI]     [xfs]


  Powered by Linux