Programmer Group

Label PostgreSQL, SQL, PLPGSQL, Drawing Pie Charts background Image is easier to understand than text. In the field of BI visualization, image is often used instead of numeric value to display some information, such as histogram, pie chart, line graph, etc. In the AWR text report, it would be good to have several more images instead of lists ...

Label PostgreSQL, memory table, unlogged table background Memory tables are often used in scenarios where persistence is not required, changes are frequent, and RT is low. At present, the community version of PostgreSQL does not have the function of memory tables. postgrespro provides two plug-ins to implement similar functions of memory tab ...

Label PostgreSQL , tpcc background Environmental Science Aliyun Virtual Machine [root@pg11-test ~]# lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 64 On-line CPU(s) list: 0-63 Thread(s) per core: 2 Core(s) per socket: 32 Socket(s) ...

Label PostgreSQL , pgbench , tpcb background pgbench is a test tool for PG. The built-in test CASE is tpcb test. It also supports users to write test CASE by themselves. A large number of custom CASE references https://github.com/digoal/blog/blob/master/201711/readme.md When we use tpcb to test CASE, if the amount of data generated is too la ...

In practice, for specific data calculation, we will find the corresponding function to implement.Different representations of computational requirements often make us use different functions or methods to implement them.Or, the same calculation can be implemented in many different ways. PostgreSQL provides a very rich set of type ...

Label PostgreSQL, intarray, ops, operator, OPERATOR, operator path, search_path, priority background Operator is one of the most commonly used elements in database. It always appears in an SQL statement. select * from tbl where id=1; Here = is the operator. Actually, the underlying operator is still a function, and the operator is a syn ...

background In recent years, with the progress of society and the development of information and communication technology, the application of information system and Internet in various industries and fields has expanded rapidly. More and more data are collected, processed and accumulated by these systems, and the increase of data ...

Set remote access, allow class B 192.168.0.0/16 segment access, and set listen_addresses ='*'. The database server is 192.168.126.128. #Modify configuration files [root@promote ~]# vim /var/lib/pgsql/11/data/pg_hba.conf #View Modification Completion Profile [root@promote ~]# egrep -v "^#|^$" /var/lib/pgsql/11/data/pg_hba.conf local all ...

Backup and restore database If the field type in odoo can be converted, you just need to click the update button in the module. If you are not allowed to modify the field type, then you need to use the following methods to backup and restore the database. speech_balloon: For example, it is allowed for integer to convert to char type, but whe ...

Author's introduction: Senior Engineer of Hu Bin Tencent Yun TOAST is the abbreviation of "The Oversize-Attribute Storage Technology", which is mainly used to store the value of a large field. To understand TOAST, we need to understand the concept of page (BLOCK). In PG, page is the basic unit of data in file storage. Its size i ...