Oracle ZFS Storage Appliance is designed to power diverse workloads so users efficiently consolidate legacy storage systems and achieve universal application acceleration and reliable data protection for data.
N/A
PostgreSQL
Score 8.7 out of 10
N/A
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.
For scenarios where the implementation is an Oracle ecosystem and the need for high-performance storage is present, undoubtedly the ideal solution is Oracle ZFS due to the native integration that exists, for example, with SPARC equipment, Exadata, and traditional architecture running Oracle Linux or Solariums (depending on the case), as well as in highly demanding industries in terms of storage.
PostgreSQL is best used for structured data, and best when following relational database design principles. I would not use PostgreSQL for large unstructured data such as video, images, sound files, xml documents, web-pages, especially if these files have their own highly variable, internal structure.
Software RAIDZ. Create storage arrays using best available RAID technologies for excellent disk stability
Array images and backups. Allows administrators to instantly create disk snapshots, to minimize time disk is unavailable (on the order of seconds, not minutes or hours).
Automatic de-deduplication/compression. ZFS will automatically de-dedup data on disk, allowing for more efficient use of the entire disk for unique data. It will also automatically compress data stored on the disk, allowing for even more usage of the available disk space. Great for infrequently accessed backups (There is some performance cost to compression).
Because it was due to a software originally designed for Solaris. configuration in other environments can be cumbersome for inexperienced implementers.
The proprietary particularity of this File System makes it in some cases very difficult to implement in highly heterogeneous environments.
I think that additional forms of integration with more environments should be created.
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.
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.
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.
ZFS is so far beyond the other filesystems available right now, offering full suites of tools for data management, backup, recovery, maintenance, monitoring, etc. It's not even fair to compare them.
Although the competition between the different databases is increasingly aggressive in the sense that they provide many improvements, new functionalities, compatibility with complementary components or environments, in some cases it requires that it be followed within the same family of applications that performs the company that develops it and that is not all bad, but being able to adapt or configure different programs, applications or other environments developed by third parties apart is what gives PostgreSQL a certain advantage and this diversification in the components that can be joined with it, is the reason why it is a great option to choose.
In highly transactional and data-intensive environments such as 200 million records per month or more.
Banking also represents an ideal niche for this type of implementation due to its high volume of data and the need for security in this industry with over 100 million records per day and online history maintenance for more than 10 years (in most cases).
The Return on Investment or ROI is clearly seen in the medium term since your storage solution would be in your safekeeping without having to pay anything additional to regular maintenance.
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.
