NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: DB of choice and sizing - feedback requested  (Read 396 times)


  • Full Member
  • ***
  • Posts: 145
    • View Profile
DB of choice and sizing - feedback requested
« on: June 13, 2019, 09:26:57 am »

Used the sizing spreadsheet - average row size - with 700 nodes, 20 DCI's per node = 14,000 DCI's, 300 sec polling (CPU per second but file Systems 1 per 15 minute - so averaged) - with a 365 day retention = 124GB. Not everything will have 365 day retention - but - taking my worst possible case.

Based on the following post - I do not appear to be pushing NetXMS so

I started with PostgreSQL and unless anyone suggests otherwise, I will go with PostgreSQL - on same server as NetXMS - with 150'ish GB of SAN based SSD storage, a couple of cores and a chunk of mem (plenty of both an a B200 M3).

Suggestions / Feedback welcome.


Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6797
    • View Profile
Re: DB of choice and sizing - feedback requested
« Reply #1 on: June 13, 2019, 09:48:52 am »

We have very good experience with PostgreSQL, that's definitely our recommendation. You may also try TimescaleDB - this is PostgreSQL extension optimized for time series data. We have added support for TimescaleDB recently and so far it shows significant performance improvement for large deployments.

Best regards,