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

"Guide" This article is divided into two parts, the first part of my motives for this conversion, and step-by-step explanation of how the existing MySQL data into the postgres. The second part will explain how to adjust PHP to the new database

The database used recently for work has been PostgreSQL, an open source database, and any individual can use the database for commercial purposes. In the use of PostgreSQL, let me the most obvious feeling is that the database is really good,

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

String Functions:The string functions in PostgreSQL are: Calculate string length functions, string merge functions, string substitution functions, string comparison functions, find specified string position functions, and so on.1. Functions to count

PostgreSQL is an object-relational database (database management system) based on the BSD license. Because of the flexibility of the license, anyone can use, modify, and distribute PostgreSQL for free for any purpose. Simply put, even if you take it

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

First, download unzip1, download postgresql-9.4.0-1-windows-x64-binaries.zip2, unzip postgresql-9.4.0-1-windows-x64-binaries.zip to E: \Second, add users1, add windows Span style= "font-family: Arial" > user, used to start postgresql windows

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

Running out of disk space in the Pg_xlog directory is a fairly common Postgres problem. This important directory holds the WAL (Write Ahead Log) files. (WAL files contain a record of all changes made to the Database-see the link for more details).

Download binary package: https://www.enterprisedb.com/download-postgresql-binariesUnzip directly to C driveMicrosoft Windows [version 6.3.9600](c) Microsoft Corporation. All rights reserved.C:\USERS\XXXX>CD

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

So far, we have processed file-based replication (or log shipping) and simple stream-based replication settings. In both cases, after the transaction is committed on master, the data is submitted and received by slave. It will still be lost at the

Strict intranet environment, no network connection, the newly installed Fedora 22 system, no other configuration.Installation 1. Installation Environment: Operating system: Fedora 22 Database: postgresql-9.4 The installation process

First, the geometry type in the PostGISPostGIS supports the "simple Features" type of all OGC specifications, and on this basis expands support for 3DZ, 3DM, and 4D coordinates.1. OGC WKB and WKT formatsThe OGC defines two formats for describing

Postgresql+slony-i installation Configuration Master-SlaveSlon Software:slony1-1.2.6http://slony.info/downloads/1.2/source/PostgreSQLhttp://www.postgresql.org/download/http://www.postgresql.org/ftp/source/v8.1.23/First, PostgreSQL installationMethod

Install PostgreSQL in Linux 1. Add a user to create a directoryUseradd Postgres-D/usr/local/pgsqlPasswd ipvsMkdir/usr/local/pgsql/Mkdir/usr/local/pgsql/DataChown-r Postgres/usr/local/pgsqlChown Postgres/usr/local/pgsql/Data 2. Set Environment

1. Connect to the correct database in the correct wayIf you want to know whether the database is connected to the correct database in the correct way, run the following command to verify the connection:SELECT inet_server_port (); this command