What PostgreSQL has over other open source SQL databases: Part II

Re:What PostgreSQL has over other open source SQL databases:... by resca79 on Saturday October 24, 2015 @08:23PM (#10445411)

Good article, but according to the post Title, I'd like to read how each features make postgres better than mysql or other, in terms of performance for example. Nice to have a list of unique features of postgres but having many indexing feature doesn't mean to be better than other dbs.

P.s. Postgres is my favourite db

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by spacemanmatt on Sunday October 25, 2015 @05:28AM (#10446449)

Many features supported by PostgreSQL but not by MySQL are the features that make PostgreSQL better for many purposes. I think you should compare the suitability of the database to the task, not databases to databases.

[ Parent | on HN ]

Re:What PostgreSQL has over other open source SQL databases:... by jeltz on Saturday October 24, 2015 @09:39PM (#10445609)

Having many indexing features allows PostgreSQL to be useful for more types of users. Many of the indexing features are primarily useful for the GIS community, where they are used by PostGIS. BRIN indexes on the other hand will primarily help for data warehousing workloads by trading performance for reduced disk space.

And GIN indexes allows fast indexing of JSON documents and for PostgreSQL's full-text search (mostly useful for quickly adding search to simple applications).

[ Parent | on HN ]