Coming October 25: PeerSpot Awards will be announced! Learn more
2020-11-06T07:13:00Z
Julia Frohwein - PeerSpot reviewer
Senior Director of Delivery at PeerSpot (formerly IT Central Station)
  • 0
  • 3

What is your primary use case for PostgreSQL?

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

26
PeerSpot user
26 Answers
SS
Software Engineer at DXC
Real User
Top 5Leaderboard
2022-02-16T09:06:03Z
16 February 22

We use PostgreSQL as a database, e.g. it's where we install the application. We also use it for all types of batch processing, and it also has the batch sequencing engine. We use it for everything, e.g. everything's right there in the database.

Moises Nájar - PeerSpot reviewer
Executive Director at Extware Consulting
Real User
Top 5
2022-01-25T17:22:46Z
25 January 22

I am using PostgreSQL to develop a general ledger system. The solution is on-premise right now, but it's going to be on the cloud soon.

DE
System/Security Engineer at a tech services company with 10,001+ employees
Real User
Top 5
2021-12-04T04:30:12Z
04 December 21

We use it for inventory control.

AA
Projects Manager at Emery Investments
Real User
Top 10
2021-12-02T13:57:00Z
02 December 21

Our primary use case for PostgreSQL is data storage.

RS
Head Channel and Capacity at a computer software company with 201-500 employees
Real User
Top 5
2021-12-02T11:09:25Z
02 December 21

We deployed the Postgre database on CentOS, which is a version of Linux. We have experimented with our replication and other operations. It works perfectly well. We are using the open-source version and do not plan on using any enterprise database.

NP
System Architect at a university with 1,001-5,000 employees
Real User
2021-10-22T09:13:54Z
22 October 21

We deploy our databases in either a local cloud or AWS. For the locally deployed database, we have our own private cloud consisting of a couple of different data centers that we partner with. For everything else, we use Oracle or Microsoft SQL. On the Microsoft SQL side, that's not usually software as a service. It's generally done as a local installation on a virtual machine. If we're doing a deployment on an AWS environment, we use the AWS Postgres database. It's slightly different than doing the installation yourself. So if you're doing the PostgreSQL installation on a Linux environment, that's usually when we're using that directly from postgresql.org.

Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
633,572 professionals have used our research since 2012.
SJ
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees
Real User
Top 5Leaderboard
2021-10-21T07:46:43Z
21 October 21

We are using PostgreSQL for databases.

Ruben Conti - PeerSpot reviewer
Owner at Intersoftware sas
Real User
Top 5
2021-10-05T20:41:00Z
05 October 21

We use PostgreSQL as a database for our ERP system.

SP
IT Systems Administrator at a transportation company with 51-200 employees
Real User
Top 5
2021-08-26T14:17:25Z
26 August 21

We use it as a backend for some vendor-supplied tools and products. We also do a certain amount of software development, and we use it as the database platform behind our own software. We have a number of deployments, and the version number very much depends on the vendor software requirements. We have on-premises and cloud deployments.

PG
Subdirector - Digital Products and Services at a media company with 501-1,000 employees
Real User
Top 20
2021-08-17T15:04:30Z
17 August 21

We use the solution for media purposes. We manage the sites of one of the largest sports business papers and multiple TV channels. So, we develop the websites.

MS
Head of Technical Support at a real estate/law firm with 51-200 employees
Real User
Top 5Leaderboard
2021-07-09T11:23:41Z
09 July 21

We use it for processing files mostly. It integrates basically with the SQL Server. On the server-side it uses the SQL Server, then from the files that are generated from SQL Server we do have an application running using Microsoft, and we attach it to a Postgres server. We do is for the backups there from time to time.

RP
IT Specialist at a government with 1,001-5,000 employees
Real User
Top 5
2021-06-18T05:31:41Z
18 June 21

We use the solution for database management and storage.

Dimitris Iracleous - PeerSpot reviewer
Lead Technical Instructor at codehub
Real User
Top 5
2021-06-15T14:22:28Z
15 June 21

We use the solution to conduct surveys and consider this approach to be one which is cheaper for us.

hugodpereira - PeerSpot reviewer
Computer engineering student at a educational organization with 501-1,000 employees
Real User
Top 5Leaderboard
2021-05-19T14:16:03Z
19 May 21

The solution is primarily used to develop the databases for your application. I used it personally for a college assignment.

VR
Full Stack Developer at a tech services company with 10,001+ employees
Real User
Top 10
2021-03-05T03:06:13Z
05 March 21

I am using the solution for data analytics, mainly for ERP because we use Hadoop and Hadoop is a dependency of PostgreSQL through the platform.

Ariful Mondal - PeerSpot reviewer
Consulting Practice Partner - Data, Analytics & AI at FH
Real User
ExpertModerator
2021-03-03T21:38:03Z
03 March 21

I have used it in the past for some web applications and back-end databases. In my current organization, we are using Microsoft SQL Server.

JP
Principal Engineer at a manufacturing company with 201-500 employees
Real User
2021-02-14T14:42:23Z
14 February 21

We design it and put it as part of our system and sell the system to various airports. We've designed our own schemas, and we track events that are meaningful to airports so that they can create their reports, view statistics, and make meaningful decisions that make sense for them.

Faustine Chisasa - PeerSpot reviewer
Engineering Supervisor- Corporate Data Solutions and Services at TZ Telecoms. Corporation
Real User
Top 5Leaderboard
2021-02-04T21:04:00Z
04 February 21

I use PostgreSQL on-premises to store monitoring data collected by the Zabbix Server. I wanted a database engine that could handle an ingress of a thousand real-time values per second, delete old items without affecting performance, and handle hundreds of user requests at all times. The solution had to support high compression and time series data while maintaining data integrity and performance. I wanted the database engine to be easy to tune, secure, and set up. PostgreSQL has regular updates and plenty of official and community resources.

Karel Van Der Walt - PeerSpot reviewer
Data Architect at ACPAS Loan Management Software
Real User
Top 5
2021-01-23T14:46:33Z
23 January 21

I have implemented costing models. I use it to capture item costs and then do calculations to compare costs.

LW
IT Innovation & Strategy | Real Estate Strategy, Asset Management & Enabling Functions | GSUS at a comms service provider with 10,001+ employees
Real User
2021-01-13T22:09:33Z
13 January 21

We use it as an intermediary database for the collection of a variety of data points out of our data systems. There are many departments that have different data, single points of truth. We asked them to give us different datasets, and we accumulated them in our Postgres-stored database. It's an intermediary for a machine learning model.

Kaan Çelik - PeerSpot reviewer
Data Analytics and Business Intelligence Manager at a computer software company with 201-500 employees
Real User
Top 5
2020-12-27T09:14:05Z
27 December 20

The database is used for our customers' products. We also offer some products on our POC system, and our customer's POC systems post some data stored on PostgreSQL on the cloud. Our company's data doesn't store at PostgreSQL. We still have our system MS SQL and Oracle.

KA
Chief technical officer at a healthcare company with 51-200 employees
Real User
2020-12-12T18:23:00Z
12 December 20

The database for the accounting systems is our primary use case for this solution. Business software is 80% of my use case in the accounting software. It's a good tool for planning. I work with financial data and the data mining aspect is very important, as I need to access the data easily. The data is the most important thing. Sometimes the software developers forget this part because they just want to save the data on the database, but they don't know how to manipulate the data. The performance of the solution is dependant on how easily and quickly you can obtain access to the data.

Jason Tumusiime - PeerSpot reviewer
Software Developer at a healthcare company with 1-10 employees
Real User
Top 20
2020-12-07T17:50:00Z
07 December 20

Currently, I'm doing a lot of source applications with Ruby on Rails, React, and mobile applications. PostgreSQL is my preferred database over MySQL. It's open-source and licenses are free, so it is excellent. The SQL queries are almost the same as MySQL.

RM
Director at a tech services company with 1-10 employees
Real User
Top 20
2020-11-26T08:52:22Z
26 November 20

We primarily use the solution for management. We have a managed ERP solution, however, it's all in-house.

MR
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
Real User
Top 5Leaderboard
2020-11-25T20:46:48Z
25 November 20

One use case is that we installed it and built it for a customer so that he has access to the database, and he can create whatever he would like to create on it. We have deployed it on-premises and in the cloud.

Diego Rosales - PeerSpot reviewer
Implementation Engineer at aldaris spa
Real User
Top 20
2020-11-06T07:13:00Z
06 November 20

I am using it to gain knowledge of the product, as I am an implementation engineer. Some clients are public organizations, migrating from Oracle to PostgreSQL.

Related Questions
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Dec 12, 2021
Which is better and why?
See 1 answer
Dovid Gelber - PeerSpot reviewer
Tech blogger
12 December 21
PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit your database with great ease. This allows you to have the kind of database that you need on a case-by-case basis. Instead of being locked into an inflexible database format, you are in control and dictate exactly what format the database will take at any given time. You can easily manipulate it, which means that you will be able to use PostgreSQL in the way that will help your organization the most. PostgreSQL is also pretty easy to use. Its designers made it so that you don’t have to have an extensive technical education to use it. It is pretty intuitive and has excellent documentation to answer any employee questions. Furthermore, PostgreSQL also offers you a cheap solution whose hosting and maintenance can be handled totally in-house. PostgreSQL’s open-source nature makes it extremely cheap to implement. Resources that might have been spent on setting it up can now be saved and redirected to areas of greater need. Furthermore, the program has two different download options. It can either be downloaded and used on-site or it can be downloaded to the cloud. Both of these allow you to be totally independent. You can host it from your headquarters or access it from anywhere you choose. Firebird SQL offers you the ability to scan your database code and search it for many types of issues. It can also compile reports based on any of the problems that it may find. However, it lacks the flexibility that PostgreSQL offers. It cannot be customized in the same way, which leaves you with fewer options. Conclusion While Firebird SQL is a fairly competent product, we found PostgreSQL to be superior. PostgreSQL’s greater flexibility and dual download options make it the more robust solution.
Ariel Lindenfeld - PeerSpot reviewer
Director of Content at PeerSpot (formerly IT Central Station)
Oct 04, 2021
Let the community know what you think. Share your opinions now!
2 out of 31 answers
PeerSpot user
Software Consultant at Infor
03 November 15
security,performance and accuracy with speed are the factory are factory which i believe to be taken into consideration
PeerSpot user
Product Line Manager at SevOne
03 November 15
I think it entirely depends on the use case. If you're looking to dig a hole, you want to evaluate shovels, not all yard tools. If my project is focused on delivering high-scale, real-time analytics, then metrics around latency, replication times, and performance are important. If I'm looking to build a large, web-based application, I would likely evaluate security, ease of scaling out/sharding, and APIs. Choose the right solution for the problems you're trying to solve. Your time should be spent on creating value and functionality, not working with flashy features of the supporting platform.
Related Solutions
Download Free Report
Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
DOWNLOAD NOW
633,572 professionals have used our research since 2012.