What users are saying about

Apache Kafka vs PostgreSQL

Apache Kafka
59 Ratings
PostgreSQL
Top Rated
223 Ratings

Apache Kafka

59 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100

Based on 59 reviews and ratings

PostgreSQL

Top Rated
223 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Based on 223 reviews and ratings

Likelihood to Recommend

Apache Kafka

Despite the disadvantages I list, I really believe that Kafka is the right choice whenever you need a queueing or message broker system. Kafka is way too battle-tested and scales too well to ever not consider it. The only exception is if your use case requires many, many small topics. Also, Kafka doesn't support delay queues out of the box and so you will need to "hack" it through special code on the consumer side.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

PostgreSQL

I don't know anyone who would choose another RDBMS other than PostgreSQL for a new project. Thanks to the wealth of field types, it can even function in situations where you might choose a document-based "NoSQL" db. Its indexing is excellent, meaning that high-performance applications with low thresholds for latency can benefit from it. It is the primary datastore that I recommend to anyone starting a new project which has relational data

Read full review

Don Burks | TrustRadius Reviewer
Don Burks
View all 39 answers on this topic

Pros

Apache Kafka

  • Apache Kafka is able to handle a large number of I/Os (writes) using 3-4 cheap servers.
  • It scales very well over large workloads and can handle extreme-scale deployments (eg. Linkedin with 300 billion user events each day).
  • The same Kafka setup can be used as a messaging bus, storage system or a log aggregator making it easy to maintain as one system feeding multiple applications.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

PostgreSQL

  • 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

Read full review

Vladimir Salnikov | TrustRadius Reviewer
Vladimir Salnikov
View all 39 answers on this topic

Cons

Apache Kafka

  • Still a bit inmature, some clients have required recoding in the last few versions
  • New feaures coming very fast, several upgrades a year may be required
  • Not many commercial companies provide support

Read full review

Juan Francisco Tavira | TrustRadius Reviewer
Juan Francisco Tavira
View all 6 answers on this topic

PostgreSQL

  • 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).

Read full review

Javier Blanque | TrustRadius Reviewer
Javier Blanque
View all 39 answers on this topic

Likelihood to Renew

Apache Kafka

Apache Kafka 9.0
Based on 1 answer
Kafka is quickly becoming core product of the organization, indeed it is replacing older messaging systems. No better alternatives found yet

Read full review

Juan Francisco Tavira | TrustRadius Reviewer
Juan Francisco Tavira
View all 1 answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 1 answer
As a needed software for day to day development activities

Read full review

Ojoswi Basu | TrustRadius Reviewer
Ojoswi Basu
View all 1 answers on this topic

Usability

Apache Kafka

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 6 answers
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.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

Reliability and Availability

Apache Kafka

No score
No answers yet
No answers on this topic

PostgreSQL

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

Read full review

Ojoswi Basu | TrustRadius Reviewer
Ojoswi Basu
View all 2 answers on this topic

Performance

Apache Kafka

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 7.0
Based on 2 answers
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.

Read full review

Ojoswi Basu | TrustRadius Reviewer
Ojoswi Basu
View all 2 answers on this topic

Support Rating

Apache Kafka

Apache Kafka 8.8
Based on 6 answers
We are using the Apache open source version of Kafka. The community is a good place to ask questions. and we can get most of our problems resolved there.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

PostgreSQL

PostgreSQL 9.3
Based on 13 answers
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.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 13 answers on this topic

Online Training

Apache Kafka

No answers on this topic

PostgreSQL

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.

Read full review

Ojoswi Basu | TrustRadius Reviewer
Ojoswi Basu
View all 39 answers on this topic

Implementation Rating

Apache Kafka

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 3 answers
The online documentation of the PostgreSQL product is elaborate and takes users step by step.

Read full review

Ojoswi Basu | TrustRadius Reviewer
Ojoswi Basu
View all 3 answers on this topic

Alternatives Considered

Apache Kafka

I would only use RabbitMQ over Kafka when you need to have delay queues or tons of small topics/queues around.I don't know too much about Pulsar - currently evaluating it - but it's supposed to have the same or better throughput while allowing for tons of queues. Stay tuned - I might update this review after we finish evaluating Pulsar. It's much less battle-tested though.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

PostgreSQL

Compared to MySQL, it works well if you need to extend to your use caseCompared to Spark, it works better w.r.t development time in a central database settingLike Redis, it cannot be used for caching and quick access of non-structured data

Read full review

Nitin Pasumarthy | TrustRadius Reviewer
Nitin Pasumarthy
View all 39 answers on this topic

Scalability

Apache Kafka

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 8.0
Based on 1 answer
The DB is reliable, scalable, easy to use and resolves most DB needs

Read full review

Ojoswi Basu | TrustRadius Reviewer
Ojoswi Basu
View all 1 answers on this topic

Return on Investment

Apache Kafka

  • Positive impact on ROI since now we can use one large deployment of Apache Kafka that can be used for multiple scenarios ( storage systems, log aggregate, messaging queue ).
  • It is open-source so there are no licenses or subscription fees reducing the cost of deployment.
  • Data can now be ingested and analyzed in real-time making it easy to fine-tune the customer experience and decision making for internal IT.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

PostgreSQL

  • By pushing a lot of logic into database views and triggers, PostgreSQL provides the ability to write much slimmer and more maintainable controller code, reducing development costs.
  • PostgreSQL's upsert capabilities enabled us to go to scale much more easily and quickly, allowing us to increase our number of customers.

Read full review

David McCann | TrustRadius Reviewer
David McCann
View all 39 answers on this topic

Pricing Details

Apache Kafka

General

Free Trial
—
Free/Freemium Version
—
Premium Consulting/Integration Services
—
Entry-level set up fee?
No

PostgreSQL

General

Free Trial
—
Free/Freemium Version
—
Premium Consulting/Integration Services
—
Entry-level set up fee?
No

Add comparison