PostgreSQL vs. MySQL: Syntax, Stored Routines, and Performance
When you compare PostgreSQL and MySQL or move a database from one to the other, SQL statements that look alike can follow different rules for routines, transactions, and…
Read articlePage 6 of 7.
When you compare PostgreSQL and MySQL or move a database from one to the other, SQL statements that look alike can follow different rules for routines, transactions, and…
Read articleWhen you backfill a large PostgreSQL table, you update values in existing rows. Change a limited number of rows that meet the update condition in each transaction, then…
Read articleWhen a query in MySQL's InnoDB storage engine makes another query wait, InnoDB usually locks entries in an index that the first query scanned, or a span of…
Read articleWhen several clients use a MySQL database at the same time, concurrency control decides which reads and writes can run together and which have to wait. “Table-level locking”…
Read articlePostgreSQL and MySQL with InnoDB both support ACID transactions: transactions that preserve data integrity while grouping changes so they commit together or roll back together. They differ in…
Read articleWhen a database transaction reads or changes rows, locks determine whether other transactions must wait before they can make conflicting changes. MySQL’s InnoDB engine and PostgreSQL both use…
Read articleWhen you choose a MySQL Server release, you decide how soon to adopt new features and how often to assess upgrades. Long-Term Support (LTS) releases keep a stable…
Read articleWhen two or more workers that use PostgreSQL need to run the same job or update the same named resource, an advisory lock lets them coordinate. The application…
Read articleWhen you change the structure of a PostgreSQL database while application instances are running, the expand and contract pattern lets old and new application versions work at the…
Read articleTo check whether PostgreSQL uses an index for a query, run EXPLAIN (ANALYZE, BUFFERS) and read the plan for the table that index covers. Confirm that PostgreSQL chose…
Read articleWhen you add an index to a PostgreSQL table serving production traffic, PostgreSQL blocks writes to the table until a regular CREATE INDEX finishes. CREATE INDEX CONCURRENTLY lets…
Read articlePostgreSQL uses multiversion concurrency control, or MVCC, to let transactions read consistent data while other transactions change it. When a transaction updates or deletes a row, PostgreSQL keeps…
Read article