2 Sep
2023
2 Sep
'23
8:19 a.m.
On 2/09/2023 at 10:53:02 PM, Ibrahim Al Mahfooz <ibrahim.nezar@sevennet.net> wrote:
Hard drives are HDD SAS 15K EPM, and logical partition set as RAID 50 (6 disks each 300GB)
With HDDs this sort of write latency seems reasonable. If you want lower latency you should get SSDs. Given you are writing mobile stuff, I can imagine that there are a lot of fairly short sessions. This would mean you have a lot of rows, and your DB size will reflect that. I don’t think you shared how many rows you have, but, 8GB of rows will be a lot. If you need this data to be retained, my suggestion is that you get someone experienced with postgres to help you design this DB and the queries. -- Nathan Ward