PostgreSQL

What is a bitmap index? Some features of bitmap indexing? What are the advantages and disadvantages of bitmap indexing? To see the example of the next image scan. QUERY Plan-------------------------------------------------------------------------

People familiar with Oracle are not unfamiliar with temporary tables (temporary table), many scenarios have a good effect on solving problems, and the concept of temporary tables in open Source Library PostgreSQL, although the same name as temporary

Windows installation processDownload the binary installation package from here and follow the prompts step by step.Service ManagementThe name of the service can be used first to services.msc viewλ net start postgresql-x64-10postgresql-x64-10 -

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

Installation Environment Windows7 64-bit systemFree Install version postgresql-10.3-1-windows-x64-binaries=======================================Decompression after unable to connect to the database, PGADMIN4 can not start, online to find a variety

I. Introduction of PostgreSQL1. What is PostgreSQLThe PostgreSQL database is the most powerful open source database available, supporting rich data types such as JSON jsonb type, array type, and custom types. And it provides a rich interface that

First, the functionKeepalived provides a health check of the objects in the server pool, and also enables fault isolation of failed machines and services, removes them from the service pool, and keepalived automatically joins the service pool if the

First, the environment#配置远程连接su postgres vim/var/lib/pgsql/9.4/data/postgresql.conf Edit configuration file listen_address= ' localhost ' before the comment # removed,  And the ' localhost ' should be ' * '; vim/etc/postgresql/8.2/main/pg_hba.conf

Concurrency control is the key technology of DBMS, concurrency control technology is also called synchronization mechanism, and its implementation usually relies on the underlying concurrency control mechanism. The operating system provides a

After the previous text PostgreSQL compilation installation and debugging (a), continue to talk about the installation and debugging PostgreSQL.The previous article explained how to compile and install PostgreSQL on a Linux system, and this time

/* In the process of writing the Greenplum function, the following two functions are found, based on the affinity of Greenplum and PostgreSQL, when determining whether a string is a numeric or date format. */--1. Determine if a string is a digital

I. Description of the orderPsql is the interactive terminal of PostgreSQL, which is equivalent to Sqlplus in Oracle. When the command is executed to connect to the database, the default user and database are Postgressecond, the command parameters-C

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

1. Check whether the Linux system installs the databaseFirst see if your system has the PostgreSQL database command installed as follows: Rpm-qa | grep PostgreSQLIf the query results are not displayed (as shown), the PostgreSQL database is not

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

Read this blog post today: https://medium.com/namely-labs/syncing-cache-with-postgres-7a4d78cec022 Once again lamented the power of pg. The original PG can also be pg_notify this method, coupled with triggers, to actively tell the external data

3.3 Do the basic backupIn the previous section, you have seen that enabling archiving requires only a few lines of command and provides great flexibility. In this section, we will see how to create a so-called base backup, which can be used later

4.4 Stream-based and file-based recoveryLife is not always black or white; sometimes there are some shades of gray. For some scenarios, stream replication may be just right. In other cases, file-based replication and PITR are what you need. However,

I. Index type:PostgreSQL provides a variety of index types: B-tree, hash, GIST, and gin. Because they use different algorithms, each index type has a suitable Query type, saving time and resources, the create Index Command creates a B-tree index.1.