psql is the PostgreSQL interactive terminal. psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. Alternatively, input can be from a file or from command … Read More
Uncategorized
Transaction Behavior in PostgreSQL
PostgreSQL provides a rich set of tools for developers to manage concurrent access to data. Internally, data consistency is maintained by using a multiversion model (Multiversion Concurrency Control, MVCC). This means that each SQL statement sees a snapshot of data (a database version) … Read More
Tags: #mvcc, #transaction
Improving Query Performance With Index
The query planner and optimizer adjust with SQL structure changes so can be impacted by changing your query. The planner generates a series of plan trees with many nodes, or steps. The trees are unique plans that vary the query … Read More
Tags: explain, index, optimizing