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
Blog
Bufisa Blog
Follow along with us as we share our experiences in the industry - the highs, the lows, and everything that falls in between.
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
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