Can Analytics database surpports the postgresql?

Support - Assistance technique
1

I see dhis.conf exeample use:

# ----------------------------------------------------------------------
# Analytics \[Optional\]
# ----------------------------------------------------------------------

# Analytics database JDBC driver class
analytics.connection.driver_class = org.postgresql.Driver

# Analytics database connection URL
analytics.connection.url = jdbc:postgresql:analytics

but doc say:

DHIS2 allows for utilizing a dedicated analytics database for analytics tables. The supported database systems are:

but can’t work for the practice, pg can or can’t?

1 Like
2

Hi @linxd

Thank you for your question! PostgreSQL is used by default, so the answer to your question is yes, PostgreSQL supports analytics. The ones you see ClickHouse or Apache Doris are optional which you can remove from the dhis.conf if you are not using them.

3

I want to use an independent db for analysis for performance. I have try all :pg/doris/clickhouse , no one success.

4
  • If your goal is simply better performance, start by tuning PostgreSQL (indexes, vacuum, partitioning, hardware resources).
  • Using Doris or ClickHouse is only recommended if you have very large datasets and the capacity to manage a second database system.
  • For most mid-size deployments, sticking with PostgreSQL as the analytics DB is simpler and stable.

Importants Links

1 Like
5

Thanks！ Happy New Year！

1 Like