IBM Informix vs. PostgreSQL

Informix is very well suited for either OLTP and OLAP transaction processing. This means that it has the best technology, concentrating both business requirements: transactional and analytical processing at the same time, as well as being able to store and process structured and unstructured data at the same time as well, and able to scale up and out if needed or required. This is why Informix is able to adapt to almost any sort of environment and satisfy almost any sort of requirement, even if the requirement is to be embedded in hardware! This last is possible because it it requires zero support and maintenance, as it can be self tuned and self healed. One of the main scenarios which is nowadays getting promoted for is the IoT one. Starting from mid 90's Informix incorporated the extensibility concept through the datablades it had brought from Illustra. This is why it is pioneer in the TimeSeries and GeoSpatial (tracking moving objects) technology, with the fastest and best storing TimeSeries techniques and GeoSpatial functionalities. The Wire Listener is one of the best features Informix has introduced to its suit of functionalities, can work in three different scenarios API types: MQTT, REST and MONGO, supporting IoT, MongoDB (an application using MongoDB can be redirected as it is to Informix-Mongo without changes) and able to understand HTTP functions (POST, GET, PUT, etc).

Incentivized

Based on my experience, PostgreSQL is exactly what I imagine when thinking of a relational database: it is fast for querying and intuitive (if the underlying relations have been well written) and its writes are also efficient. Of course you need to know that a relational database is what you need, for example I would not recommend it if you have a lot of unstructured data that have no way to create a relation from and if you need to run heavy aggregations over your data, as it is not where PostgreSQL would shine.

Incentivized

• Informix since its conception has a distinct multi-threading architecture no other engine has, it is unique of its kind. This is precisely how the engine is able to scale up like no other, with the lowest footprint, without killing the host and profiting each bit of the hardware. The threads are sub-proceses like any other one, but the difference is that they are are not controlled by the OS process dispatcher. This is why you will never be able to see these threads running at OS level. Informix is an OS itself, on top of the OS.
• Informix has the best replication techniques. Not many ppl know that MongoDB (the NoSQL engine) scales out because of its data sharding replication technology, and Informix is able to store Mongo BSON documents using the same data partitioning as MongoDB does. This way Informix extends the SQL or structured data with the unstructured data natively, together within the same data repository. This means that it is not only able to store JSON/BSON documents, but the engine is able to behave as it would be the MongoDB engine itself. Any application using MongoDB can be redirected to the Informix Mongo wire listener transparently. What´s more, it also improves the NoSQL (BASE) characteristic, making it ACID by allowing transactions to the CRUD operations. This last is something MongoDB is working on, promised to be delivered next year.
• As described previously, MongoDB's sharding concept relies on data partitioning, this is how it scales out, and as I also described previously Informix scales up given the described multithreading unique architecture! It implements the data sharding with one of its best replication technologies called Enterprise Replication. This is an Active-Active replication technology that allows replicating even between different platforms. This is actually how I managed to migrate the whole Informix platform from Solaris to Linux, with just a DNS change. There was almost ZERO downtime nor application change - this was really amazing!.

Incentivized

• The stability it offers, its speed of response and its resource management is excellent even in complex database environments and with low-resource machines.
• The large amount of resources it has in addition to the many own and third-party tools that are compatible that make productivity greatly increase.
• The adaptability in various environments, whether distributed or not, [is a] complete set of configuration options which allows to greatly customize the work configuration according to the needs that are required.
• The excellent handling of referential and transactional integrity, its internal security scheme, the ease with which we can create backups are some of the strengths that can be mentioned.

Incentivized

• No major on this system just the security setting.
• Big data transfer slows performance.
• Ability to manage huge amount of different data type requires a professional.

Incentivized

• The query syntax for JSON fields is unwieldy when you start getting into complex queries with many joins.
• I wish there was a distinction (a flag) you could set for automated scripts vs working in the psql CLI, which would provide an 'Are you sure you want to do X?' type prompt if your query is likely to affect more than a certain number of rows. Especially on updates/deletes. Setting the flag in the headless(scripted) flow would disable the prompt.
• Better documentation around JSON and Array aggregation, with more examples of how the data is transformed.

Incentivized

Informix is the best RDBMS on the market. Period.

Incentivized

As a needed software for day to day development activities

Incentivized

Server management is easy enough to be able to embed the engine in a device and let it run for years without maintenance.

Incentivized

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.

Incentivized

PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.

Incentivized

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.

Incentivized

The Informix product support team has won awards and is appreciated by the entire Informix user community.

Incentivized

There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.

But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.

Incentivized

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.

Incentivized

The online documentation of the PostgreSQL product is elaborate and takes users step by step.

Incentivized

IBM Informix unlike the tools above creates effective solutions for big data extraction and data transportation functionalities across the entire Cloud services and the Automation ability is the best. The security that IBM Informix provides for all our business data and other project information and contacts is effective and the reports are very clean and easy to understand.

Incentivized

In my experience using all of these products over many years, PostgreSQL is better than any of them in reliability, performance, productivity, cost, scalability and interoperability across operating systems.

Incentivized

The DB is reliable, scalable, easy to use and resolves most DB needs

Incentivized

• Although I do not own nor have visibility on my company's figures:
• Informix generates consistent savings on DBA staffing, no need for many DBAs as other DBMS require.
• The replication architecture allowed consistent savings in the infrastructure as well as developments and maintenance, the job is already done, no need to develop complex and costly solutions, it's just a matter of configuring it.
• The advantages of hybrid development (i.e mixing SQL and NoSQL in the same database) is not just a marketing hype: it allowed us to solve with a brilliant solution, in one afternoon of coding, a functional problem we have been having for more than 10 years!
• The biggest drawback is that IBM pricing may be constraining, it has too important gaps between the mid range and highrange in terms of pricing

Incentivized

• A robust and reliable platform reduces the risk of data loss and confusion.
• Using an almost free product is economical. No license fees = minimal ownership cost.
• Efficiency is high due to quickness and excellent resource management.
• PostgreSQL helps us achieve our goals, and there are no time-consuming management tasks.