4 ms·
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.
by resca79 11y ago
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
- jeltz 11y agoHaving 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).
- spacemanmatt 11y agoMany 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.