PostgreSQL

PostgreSQL performance does not lose MySQL, and support many advanced features, so I wrote this project, according to LIBPG C drive, encapsulated the Nodejs driver.Project Address:git clone https://code.csdn.net/limite_god/pgsql.gitDevelopment

1. Tool Softwarepg_bloat_check.py (Pg_bloat_check-master.zip)Https://github.com/keithf4/pg_bloat_checkPackage Requirements:1). PGSTATTUPLE,PG source Crontrib directory.2). Python above 2.6.3). argparse-1.4.0.tar.gz4). psycopg2-2.6.2.tar.gz5).

Collated the way PostgreSQL imports and exports related schemas.First, export:Export the schema table structure and data of CRM in his library (-n parameter):p g_dump-h 192.168.2.154 -P 5432-d his-n crm-f Test.sql Only export the schema table

When connecting to a remote server PostgreSQL on a network, inactivity will automatically disconnect for a longer period of time and is not conducive to operation. Figured out, this problem was resolved when the following network configuration was

There are two tables t1,t2, the table structure and the data are as follows:CREATE TABLE T1 ( ID int), CREATE TABLE T2 ( ID int, finished int), insert into T1 values (1); INSERT into T1 val UEs (2); INSERT into T1 values (3), insert into T1

1. Environment Preparation:A) Install PowerDesigner, take PowerDesigner15.1 as an exampleb) Install Java JDK, take jdk-7-windows-i586 as an examplec) Download the Postgressql JDBC driver jar package, taking Postgresql-8.1-415.jdbc2.jar as an

When the PG installation is complete, the log is not logged by default and the corresponding (${pgdata}/postgresql.conf) configuration must be modified to only describe the common log configuration.1.logging_collector = on/off ----whether to

A field can be assigned a default value. If a new row of data is created, and the values of some fields are not declared, the fields are populated with their respective default values. A data modification command can also explicitly require that a

Table structure and dataSelect Logdatetime,sum (login) as login,sum (logo) as logoFromSelect Date (logdatetime) as "Logdatetime", Case logfrom if ' login ' then COUNT (ID) Else 0 end as "login",Case Logfrom if ' logo ' then COUNT (ID) Else 0 end as "

The Navicat for PostgreSQL database uses users and groups to manage database access permissions, and users have database objects, such as databases, on which you can specify permissions to other users, and control the scope and permissions of other

The Navicat for PostgreSQL operator category defines the specific data type that is used with the index, and the operator category specifies that some operators will fill a specific role or "policy" for the data type and index method, and also

PostgreSQL can never accept more than about 125 connections at the same time, my hardware is very powerful! This happens because some PostgreSQL says that dependent libraries depend on user32.dll, and user32.dll to allocate memory from the Desktop

postgres=# Create type Complex as (Postgres (# R Double Precision,Postgres (# I double precisionPostgres (#);CREATE TYPEpostgres=# Create type Inventory_item as (Postgres (# Name text,Postgres (# supplier_id Integer,Postgres (# price numeric);CREATE

Objective:Recently do data synchronization, need to get data from PostgreSQL, found that once the data is more, then the speed of reading is very slow, and memory consumption is very much &GC not fall.Code Sample:In order to facilitate the

First, prepareConnect on master node to create replication user# CREATE ROLE Replicator with login replication password 123456;Modify Whitelist pg_hba.conf# Host replication All XXXXX/32 MD5Second, make the basic backup# pg_basebackup --format=tar \ 

Original address: http://blog.chinaunix.net/uid-26642180-id-3485465.htmlI've been learning PostgreSQL recently, and here are some of the common commands that I've compiled for PostgreSQL.Connect to the database, the default user and database is

5.2 Understanding actual impact and performanceIn this chapter, we have discussed the actual impact as well as the performance impact. But is there any good theoretical example? Let's do a simple benchmark test to see how replication is done. We do

Lateral is a content referral service provider whose simulations use PostgreSQL to store documents. Each document contains a text column and a JSON column that stores metadata such as the title, date, and URL. They want to create a quick search

Background introduction:PostgreSQL server execution on Redhat linux, IP: 192.168.230.128Client is installed on Windows XP with IP: 192.168.230.1Configuration method:1. Change the server/opt/postgresql/data/postgresql.conf file to#listen_address = '

1. Change the table namealter table 表名 rename to 新表名2. Change the field namealter table 表名 rename 字段名 to 新字段名3. Change the field typeFor example: ID field Original type is character varying (50) new type is integerWhere the ID has data for the