PostgreSQL Manufacturing Reviews & Insights

Score8.4 out of 10

336 Reviews and Ratings

Community insights

TrustRadius Insights for PostgreSQL are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Reliability and Performance: Users have consistently praised PostgreSQL for its reliability and performance, with many reviewers stating that they have experienced no downtime or issues related to the database. Some users also mentioned that PostgreSQL's performance is exceptionally fast, providing them with great speed in their operations.

Ease of Use and Flexibility: Many users find PostgreSQL easy to use and appreciate the availability of good open-source tools to work with it. Reviewers have highlighted that constructing queries in PostgreSQL is straightforward and that it integrates well with all development languages, making migration easy. The flexibility of PostgreSQL's user/role management system has also been praised by users, as it allows for easy control over access to tables.

Wide Industry Adoption and Community Support: Several reviewers acknowledge that PostgreSQL has achieved wide industry adoption, making it easier to integrate into a stack and hire knowledgeable developers. The availability of a huge online community for support was highly appreciated by users. Additionally, many users mentioned the extensive documentation available for PostgreSQL, along with the ease of finding examples, which further contributes to community support.

Reviews

2 Reviews

Manufacturing

PostgreSQL Review

Rating: 8 out of 10

Incentivized

April 13, 2021

Use Cases and Deployment Scope

Using PostgreSQL in all aspects of the company. Using it for our front-end platform to display data. Using PostgreSQL as part of our pipeline looking up reference data. Also using it for reporting purposes as well. The data we have is structured, but with some unstructured data, the jsonb datatype support, also helps us considerably to store dynamic data generation. Helps us scale out our platform.

Pros

Aggregation of data quickly for report generation
Lookups of reference data vs looking up in files
organization of data for quick references
quick ansi sql functions vs writing out functions in program language

Cons

regex isn't as strong
parallelization of querying of data
data distribution natural sharding

Likelihood to Recommend

Like any RDBMS, it's perfect for storing structured and sometimes non structured data in the db engine. Transactional data is perfect for PostgreSQL. OLAP data works well.
What it's not suited for, is large document stores. This is where PostgreSQL doesn't do well, compared to mongo. however, newer releases show that it is getting there. Genomic data (raw data) is not suited for PostgreSQL. And PostgreSQL engine alone is not suited for timeseries data. But with extensions in place, works really well.

Anson Abraham

Data Czar in Engineering at Envisagenics, Inc. (Biotechnology, 11-50 employees)

Vetted Review

10 years of experience

View profile

PostgreSQL with PostGIS - best way for rapid development spatial-engaged services

Rating: 10 out of 10

Incentivized

April 2, 2021

Use Cases and Deployment Scope

I've used PostgreSQL for managing the database for agriculture support system with elements of spatial analysis by PostGIS extension. This was an internal software (not intended for public markets), used by agronomists, management, and shareholders of agricultural holdings in South Russia, Volgograd region. The database includes records about crop rotations, vegetation indices, field observation data, weather data, etc. By this info, used in analytic to achieve better productivity and reduce expenses for common field works, used to grow bulk crops, such as wheat, corn, and sunflower.

Pros

Advanced spatial capabilities by using PostGIS extension
Very fast data processing and support of native ANSI SQL language syntax allows maintaining capability and scalability of database
Fast data aggregation, even by SQL or stored routines/functions
Well documented, free for use, great community. A lot of examples, and for this reason - lesser threshold for junior developers to start with

Cons

Clustering and distributed processing is difficult to use and maintain

Likelihood to Recommend

In my humble opinion, the best area to use PostgreSQL - is small and medium databases with several billion or tens of billions of records/entities with some spatial attributes analytics involved in the data processing pipeline, if needed. Using PostgreSQL with the conjunction of PostGIS extension and some other open-source software such as QuantumGIS, Leaflet, etc allows users rapidly create spatial data analytics software, maintain and modify it with few resources spend.

Vladimir Salnikov

Lead Engineer in Information Technology at Bee Robotics (Food Production, 1001-5000 employees)

Vetted Review

3 years of experience

View profile

Loading Reviews List....