PostgreSQL Tutorial (10): Performance Promotion Skills _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

PostgreSQL installation and simple use 1th/2 page _postgresql

According to my understanding of the four domestic databases, three of which are based on PostgreSQL development. And, because of the flexibility of the license, anyone can use, modify, and distribute PostgreSQL for any purpose, whether for private,

Brief introduction to Ruby on Rails support for PostgreSQL array types _ruby topics

I'm very happy to announce that Rails 4.0 now supports PostgreSQL array types. You can easily create a field of an array type in migration through: array => true. You can also add other options when you create fields of an array type (Length,default,

PostgreSQL High Availability cluster installation

I. Hosts and topology structure of PG cluster1.host infosCLUSTER01_NODE01 192.168.0.108CLUSTER01_NODE02 192.168.0.109CLUSTER02_NODE03 192.168.0.1102.topology structure sync asyncPrimary (CLS01_NODE01)--

Sequelize node.js/io.js ORM for Postgresql,mysql,sqlite and MSSQL

installationSequelize can be obtained from NPM.$ npm Install----save pg pg-// for both MySQL and mariadb dialects$ npm Install-- // MSSQL Establish a connectionSequelize will set up a connection pool at initialization time, so

Linux CentOS 7 Installation PostgreSQL 9.5 (source code compilation)

ObjectiveThe previous blog records the installation of PostgreSQL 9.3 in the form of RPM packages (Linux CentOS 7 Installation PostgreSQL 9.3 (release)), and this blog will record the installation of PostgreSQL 9.5 in the form of source code

Installation and configuration of the CentOS 6.3 under PostgreSQL

First, IntroductionPostgreSQL is a very complex object-relational database management system (ORDBMS), and is currently the most powerful, feature richest and most complex free software database system. Some features don't even have a commercial

PostgreSQL Beginner Tutorial

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

Considerations for installing the "Go" PostgreSQL database on Windows Server 2008

Windows Server 2008 differs from the normal version of Windows in that it has more restrictive file/directory control permissions. PostgreSQL database is also a "Unix/linux service" program design, also has its own permissions rules, therefore,

PostgreSQL database installation and simple operation

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

Introduction to PostgreSQL Novice

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

Windows manual installation of PostgreSQL 9.0 zip uncompressed version

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

centos6.4 install PostgreSQL and client remote connections below

First, installationcentos6.4 Server ip:192.168.220.131WINDOW7 Client ip:192.168.199.218Install PostgreSQL via the following instructions on the CentOS website http://www.postgresql.org/download/linux/redhat/It seems to have been installed, the

PostgreSQL Service Deployment

PostgreSQL is a very complex object-relational database management system (ORDBMS), and is currently the most powerful, feature richest and most complex free software database system.os:centos6.5 x64ip:192.168.85.130Hostname:vm2.lansgg.comPG Version:

The first chapter of PostgreSQL Replication Understanding Replication Concepts (2)

1.2 Different types of replicationNow that you have completely understood the limitations of physics and theory, you can start learning different types of replication.1.2.1 Synchronous and asynchronous replicationThe first distinction we can make is

PostgreSQL source analysis of shared buffer and disk files

We know that the information in the PostgreSQL database is ultimately written to the persistent device. So how does PostgreSQL store the information organization on disk? Bruce Momjian has a slide "insider PostgreSQL Shared Memory", inside the

Use of Postgresql+postgis

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 learning Manual (9) Server Configuration

1. Start and close server processes: The following are the usage and common options of the pg_ctl command. It should be noted that this command is the encapsulation body of the S command, so it is more convenient to use than using Postgres directly.

A bug in the parameter object in the. NET driver npgsql of postgresql

Recently, I migrated my project from sqlserver to the PostgreSQL database. When I called the database Stored Procedure (User-Defined Function), I found a strange problem. I always reported that the function could not be found. First look at a

How to modify the oId of a table in PostgreSQL

Oid is a hidden column of the system. Direct modification is not acceptable.MySQL = # update pg_class set OID = 99999 where OID = 73728;Error: cannot assign to system column "oid"Line 1: Update pg_class set OID = 99999 where OID = 73728; But we can

Total Pages: 77 1 .... 11 12 13 14 15 .... 77 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.