How Index-Only Scans Work in PostgreSQL
PostgreSQL stores table rows in a heap, the table's main storage, and keeps indexes separately. When a query needs only values stored in an index, PostgreSQL can use…
Read articlePage 2 of 6.
PostgreSQL stores table rows in a heap, the table's main storage, and keeps indexes separately. When a query needs only values stored in an index, PostgreSQL can use…
Read articleWhen a service connects to PostgreSQL, the database opens a server process to handle that client’s queries. PostgreSQL’s maxconnections setting limits how many clients can connect at once.…
Read articleIn PostgreSQL, an UPDATE creates a new row version, and a DELETE marks a row version as deleted. The old versions stay in the table while a transaction…
Read articleWhen you add a column to a PostgreSQL table that handles live traffic, the result depends on the column’s default and on what else the migration does. For…
Read articleWhen two database transactions try to change some of the same data, the database uses locks to let one proceed while the other waits. PostgreSQL and MySQL’s InnoDB…
Read articleWhen a busy PostgreSQL table needs an index, a structure that helps PostgreSQL find rows, use CREATE INDEX CONCURRENTLY to let inserts, updates, and deletes continue while PostgreSQL…
Read articleWhen you change the schema of a busy PostgreSQL database, each data definition language (DDL) command determines what PostgreSQL does and which other sessions wait. DDL commands are…
Read articleWhen your PostgreSQL database handles reads and writes at the same time, ordinary SELECT queries often keep running without waiting for updates. PostgreSQL uses multiversion concurrency control (MVCC):…
Read articleIn PostgreSQL, a query sees an inserted row based on the transaction’s isolation level and when the query starts. At the default Read Committed level, PostgreSQL gives each…
Read articleTransaction state, MVCC, and atomicity In PostgreSQL, BEGIN starts a transaction that groups several statements so they succeed or fail together. COMMIT makes the changes visible to other…
Read articleIn PostgreSQL 8.0, transaction isolation controls what one transaction sees while other transactions change the database. PostgreSQL uses multiversion concurrency control (MVCC): it keeps different versions of rows…
Read articleWhen two PostgreSQL sessions work at the same time, one can read a row while the other updates it. A transaction is a group of database operations that…
Read article