Programmer Group

operating system Modify / boot/grub2/grub.cfg Navigate to the first 'menu' CentOS Linux 'and add it on the last side of "linux16 /vmlinuz" numa=off transparent_hugepage=never default_hugepagesz=2M hugepagesz=2M hugepages=1536 *hugepagesz indicates the page size. Choose one of 2M and 1G, and the default is 2m. hugepages ...

PostgreSQL black technology - recursive dichotomy for Chinese character segmentation This article is PostgreSQL fuzzy query In the improved version, the number and English words are extracted separately without segmentation. 1. Create a punctuation function in the clear text At present, the punctuation I can think ...

Create a table in the postgresql line, highgo=# create table abcd (int int); CREATE TABLE Then create a table with the data type of the column using the table name you just created. highgo=# create table abcde (abcd abcd); CREATE TABLE Created successfully. Will each created table generate a type with the ...

background Recently, I was in charge of transferring company data from Oracle to PG; old platform database: Oracle11g; new platform database: PostgreSQL12. Due to the change of platform statistical rules, all the game data being promoted cannot be migrated; it can only run on the old platform. The payment data interface is upgraded, and the da ...

Logical Structure of Database Cluster Database Cluster -- database cluster, which is a collection of a group of databases rather than multiple database servers Database -- database, a collection of database objects Database object -- database object, a data structure used to store query data Database cluster > Database > database ...

Source code: GitHub point here || GitEE point here 1, Introduction to PostgreSQL 1. Database introduction PostgreSQL is a powerful open source database system, which has the characteristics of reliability, stability, data consistency, and can run on all major operating systems, including Linux, Unix, Windows, etc. PostgreSQL is a complete tran ...

1. background PostgreSQL's HA schemes are generally based on its native stream replication technology, supporting synchronous replication and asynchronous replication modes.Although the synchronous replication mode can ensure the data is not lost to the greatest extent, it usually needs to deploy at least three machines to ensure that there ar ...

Recent projects require the configuration of a four-node cluster of shared storage to enable the cluster to form a load balancing.   However, you know that PostgreSQL does not support the generation of multiple instances using the same data directory. When executing pg_ctl start, if an instance of the specified data directory is running, the ...

Group concat is an aggregation function in mysql, but PostgreSql does not have this function, but it can be implemented with string AGG function Source: https://blog.csdn.net/u011944141/article/details/78902678 array_agg(expression) To change an expression into an array is generally used in conjunction with the array ...

Because the company changed the server service provider and the server was migrated to another service provider, today we will simulate the operation of online migration of gitlab git-A IP:192.168.82.184 git-B IP:192.168.82.184 If the version number is the same, the backup migration will fail   Step 1.gitlab backup gita-A #c ...