PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.
N/A
VictoriaMetrics Community
Score 8.5 out of 10
Enterprise companies (1,001+ employees)
VictoriaMetrics is a high-performance monitoring solution and time series database
N/A
Pricing
PostgreSQL
VictoriaMetrics Community
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
PostgreSQL
VictoriaMetrics Community
Free Trial
No
Yes
Free/Freemium Version
No
Yes
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
Optional
Additional Details
—
Enterprise support prices are negotiated individually with every customer. The price depends on many factors such as:
* Costs for the existing monitoring solution
* The amounts of collected data and the workload specifics (unique time series, churn rate, ingestion rate, query types, query rate, etc.)
* The amounts of compute resources needed for the monitoring solution
* Additional enterprise features
* SLA tier
Contact us at info@victoriametrics.com for more details on the pricing.
PostgreSQL is ideal for handling databases that contain large volumes of information due to its efficiency, speed and above all because of the good management it makes of our resources, it also behaves very well in distributed environments of high demand, if you want a database of stable data and excellent performance PostgreSQL is one of the best.
1. It is well suited when you need to monitor large scale of metrics as compared to Prometheus it is faster,more reliable and can provide you metric for more retention period. 2. Uses less resource to run application , can easily be containerised 3. It supports both push and pull models and can be intergated with multiple alerting systems
The performance of PostgreSQL has been enhanced through the years, but always is better to have as much performance as we can.
The replication services could be done directly within the database, and more easily.
The Object Orientation of the Database could be extended, and albeit it manages inheritance of tables, and accepts XML and JSON as primary types, it would be wonderful if one could attach methods more easily to tables (to make them more like classes), and instances (rows for example).
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
AWS, Heroku, and Digital Ocean all provide Postgres-as-a-service, where you pretty much never need to administrate it yourself but they do it for you. The Postgres community also has developed awesome and reasonably priced extensions, such as Citus DB and CockroachDB in case you need additional support for running it. If you need documentation, Postgres's docs are super thorough and their official forms are active.
The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
In this case, Postgres is preferred because it handles large data sets and requires fewer hardware resources than its competitor, MySQL. Compared to PostgreSQL, Microsoft products are excellent, but the installation process for MS SQL is lengthy. PostgreSQL has an advantage over its competitors in that it can adapt or configure third-party programs, applications, or settings.
Victoria metrics is cheaper and more efficient than Prometheus, in terms of data ingestions, hardware resources, and Storage mechanism, also supports Prometheus extensions, and query language by default. Although Prometheus has a larger community and support, because of the interoperability of Victoria metrics the difference wouldn't concern us much. At the same time, it made our migration simpler
Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
