PostgreSQL

PostgreSQL has a very useful function, partition table, or partitioning. When the record of a table is very much, or even more, we actually need to split him into a child table. A huge table, like a fruit warehouse stacked with countless apple

One of the big selling points of the Postgre database is the way it handles concurrency. Our expectations are simple: reading never blocks writing, and vice versa. Postgres this through a mechanism called multiple versioning concurrency control

1. Use of explainThe explain command can view the execution plan, as already described in the previous blog. This method is our most important debugging tool.2. Update the statistics used in the execution plan in a timely manner Since statistics are

Background Car shift is smooth, usually depending on the number of stalls, or shifting technology. The more the number of stalls, shifting feeling will be about smooth, less number of stalls, the shift may have more obvious duncuo feeling.

0. Help$/home/lhl/az/pg/bin/pg_ctl--Helppg_ctl is a utility to initialize, start, stop, or control a PostgreSQL server. Usage:pg_ctl INIT[DB] [-D DataDir] [-S] [-O"OPTIONS"] Pg_ctl start [-W] [-t SECS] [-D datadir] [-S] [-l FILENAME] [-O"OPTIONS"]

Access to the Bin folder under PostgreSQL, you will see a lot of EXE files, this is the PostgreSQL built-in tools. Inside will find Pg_dump.exe. That's what we're actually using.Usage:1 . CD C:\Program files\postgresql\ 9.3 \ Bin 2 -H localhost-u

When PostgreSQL adds a new server connection, an error occurs:Workaround:First step: Modify the list of servers connected in the configuration file and add the server IP address (figure Pg002.png)Profile Address: Database Right-click Properties,

Installation Environment:Ubuntu 10.04-desktop-i386PostgreSQL 8.41. Installing PostgreSQLEnter the following commandsudo apt-get install PostgreSQLYou will be prompted to install the required disk space, enter "Y" and the Setup program will complete

Inheritance is the concept of an object-oriented database. It opens the door to new and interesting possibilities for database design.Let's create two tables: a cities table and a capitals table. Naturally, the capital is also the city (cities), so

CREATE AGGREGATE Rbitmap_union2 (rbitmap) ( sfunc = myfunction, stype = MyType, finalfunc = myfunction_final );When you write an aggregate function, the same function is called repeatedly for each row, and if the data to be processed is

MySQL cannot support the data version from the most basic data engine to the process structure. Causes its function to block "concurrency", does not support the most basic transaction, InnoDB does not reach the basic transaction requirements, any

The common INSERT statement in MyBatis is this: "table_name" (key, value) values ( #{key,jdbctype=VARCHAR}, #{value,jdbctype=The public integer insert of the DAO interface at this time (Databaseobject do); The returned Integer is the number of

Pentaho Data Integration (kettle): A great tool for extracting, converting, loading (Extract Transform and Load,etl)Pentaho report Server: A powerful reporting enginePgAdmin3: An excellent database management toolPhp5-postgresql: A package for PHP

Recently saw the topic of PostgreSQL more, search for it and MySQL comparisonCicadaLinks: http://www.zhihu.com/question/20010554/answer/74037965Source: KnowThe advantages of PG relative to MySQL:1, the standard implementation of SQL is better than

Encounter a hole: for the following codeSelect * from where > ' 2015-11-1 ' and date'2015-11-5'Results can be obtained when executed in the client of PostgreSQL, but when executed in Java (the time range is a parameter, type string), such as Date &

Export Import of PostgreSQL dataTo export data from a PostgreSQL database:$ pg_dump-u postgres-f mydatabase.sql mydatabaseWhen importing data, first create the database and then import it with Psql:$ createdb Newdatabase$ psql-d newdatabase-u

I. Deployment notes1.1 Implementation EnvironmentThe experimental environment for this document is as follows:Pgsql Host: 192.168.1.45Pgsql Standby Machine: 192.168.1.50Software and system versionsPgsql version: Pgsql 9.2.4Linux version: Redhat 5.81.

In the server load status monitoring, in order to avoid the load spikes caused by the useless alarm problem, I used to take the last 10 times the average load. This requirement was solved directly in Django, but the speed was not ideal after a

Export the database data1 to a file in the shell with Command pg_dumppg_dump-d data1-f Test.txtOrpg_dump-d data1 > Test.sqlAnd then create an empty libraryCreatedb data2Import data1 data into data2 with the Psql commandpsql-d data2-D data2 Pg_dump

MySQL License charges become more and more realistic. PostgreSQL has become the best alternative.Deployment environment: CentOS6.3 x64.PostgreSQL version: 9.2.4-1.The CentOS Develop package Mode line may already have a PostgreSQL database, but the