Re: Recommended settings for PostgreSQL

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

 



Hi,

After reading few sources, I decided to use dedicated NVMe Disk with native replication. Those benchmarks and performances I was referred for internal use only. Not much data stored there. I believe for production usages, it will deliver more trouble than advantages.

Thanks,
Gencer.
On 17.10.2020 18:39:44, Gencer W. Genç <gencer@xxxxxxxxxxxxx> wrote:
Hi Irek,

In the past I see some good results (benchmark & latencies) for MySQL and PostgreSQL. However, I've always used 4MB object size. Maybe i can get much better performance on smaller object size. Haven't tried actually.

Why are you not recommending this setup actually?

Gencer.

On 17.10.2020 18:01:19, Irek Fasikhov <malmyzh@xxxxxxxxx> wrote:
Hi,
Ceph for a transaction database bad solution from medium loads.


сб, 17 окт. 2020 г. в 16:29, Gencer W. Genç <gencer@xxxxxxxxxxxxx [mailto:gencer@xxxxxxxxxxxxx]>:

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 [mailto:ceph-users@xxxxxxx]
To unsubscribe send an email to ceph-users-leave@xxxxxxx [mailto: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