PostgreSQL

First, the use of explain: PostgreSQL generates a query plan for each query because the performance impact of selecting the correct query path is critical. PostgreSQL itself already contains a planner for finding the optimal plan, and we can view

First, Introduction PostgreSQL provides a number of system management functions to view tables, indexes, table spaces, and the size of the database, described in detail below. second, the Database object dimension function The name

First, installationFirst, install the PostgreSQL client.sudo apt-get install postgresql-clientThen, install the PostgreSQL server.sudo apt-get install PostgreSQLNormally, when the installation is complete, the PostgreSQL server will automatically

The PostgreSQL database is a high-performance, full-featured, open-source relational database that explains how to install PostgreSQL 10 under Ubuntu 16.04 LTS.Add a software sourcewget -q -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc |

Tag: Select the complete sequence process date ready version to generate the calculationPostgreSQL transaction processing and concurrency control:A transaction is the basic unit of work in PostgreSQL and is a user-defined sequence of database

First, IntroductionPostgreSQL introduces a master-slave stream replication mechanism after 9.0, so-called stream replication is the synchronization of the corresponding data from the server through the TCP stream from the primary server. This will

Since MySQL was acquired by Oracle, PostgreSQL has become the first choice for open-source relational databases.This article describes the installation and basic usage of PostgreSQL for first-time users to get started. The following is based on the

What is stored procedure, Baidu Encyclopedia is so defined: the stored procedure (Stored Procedure) is in a large database system, a set of SQL statements in order to complete a specific function, stored in the database after the first compilation

What is the latency between the PostgreSQL database stream replication master and standby and should be evaluated for both HA and load balancing. A simple HA architecture, for example, is how much time we allow for data loss in the event of a

Recently there is a database of projects using PostgreSQL, using the original ecological mybatis operation data, the original ecological Nothing bad, But there is a tk.mybatis tool in the country to help us do a lot of practical things, most of the

PostgreSQL Learning Notes (v) Backup and recovery1. Backup tools: Pg_dump and Pg_dumpallThe pg_dump can back up a specified databasePg_dumpall can back up all database data and system global data at once2. The Pg_dump and Pg_dumpall tools do not

1. Initial state: Master,slave are running states.2. Upgrade processMaster1). Turn off the master record last checkpoint location (latest checkpoint locations), which is where the downtime begins (this is where your downtime starts).The Postgres

Previously studied PostgreSQL's notesCREATE TABLE consumption OID create table My_ test_table, He's going to consume a pg_type insert two records _my_ test_table my_test_table oid If the table requires Toast will

PostgreSQL Learning (I.)1. The special place of PostgreSQL and the reason of choosing(1) PostgreSQL supports writing process and functions in various programming languages(2) PostgreSQL supports very powerful user-definable data type features2.

First, download unzip1, download Postgresql-9.0.1-1-windows-binaries.zip2, unzip Postgresql-9.0.1-1-windows-binaries.zip to D:\Second, add users1. Add Windows user to start PostgreSQL Windows serviceD:\pgsql>net User Postgres

If you have an account with Windows Azure, you can apply for a free trial account on the Windows Azure China website If you don't have one. Haha, I am the first batch of application of the trial account, I feel very lucky. The application process

Original: http://www.cnblogs.com/stephen-liu74/archive/2012/04/25/2291526.htmlA database contains one or more named patterns, and the schema contains the tables. The schema also contains other named objects, including data types, functions, and

Since MySQL was acquired by Oracle, PostgreSQL has become the first choice for open-source relational databases. This article describes the installation and basic usage of PostgreSQL for first-time users to get started. The following is based on the

This tutorial records the Spark 1.3.1 version of Thriftserver Metastore docking PostgreSQLPostgreSQL compilation, reference: Http://www.cnblogs.com/chenfool/p/4530925.htmlOne-start PostgreSQL service1 First, you need to load PostgreSQL lib into the

Epoch time is based on 1970-01-01 00:00:00 UTC as standard time and will target time with 1970-01-01 00:00:00The difference in time is calculated in seconds, in seconds, and can be negative values; Some applications store time in the Epoch time form