Good day, I have such a question, the MySQL database is clear, there are table types such as:

  • MyISAM
  • InnoDB
  • ARCHIVE
  • FEDERATED
  • MEMORY
  • Merge
  • BLACKHOLE

And in the PostgreSQL database, what are the table types? Are there any differences from MySQL?

    2 answers 2

    To connect third-party engines in PostgreSQL, the Foreign Data Wrapper (FDW) mechanism is used http://www.postgresql.org/docs/9.4/static/postgres-fdw.html . You can see a list of all current FDWs at https://wiki.postgresql.org/wiki/Foreign_data_wrappers

      Splits by table storage engines (such as MyISAM or InnoDB in MySQL) are not in postgresql. However, tables can be created with TEMPORARY flags (temporary tables, automatically deleted after session termination) or UNLOGGED (disabled logging — queries run faster, but the table can be damaged if postgresql is not completed correctly, such tables cannot be replicated by standard postgresql tools).