Programmer Think

The catcache code is located at src/backend/utils/cache/catcache.c, which contains links and operations to initialize SysCache structures and pointer relationships between data structures. Finding tuples in CatCache There are two ways to find tuples in a CatCache: exactly matching the SearchCatCache and partially matching the SearchCatcac ...

Case description: For the cluster log of KingbaseES R3 cluster, the default system does not cut and clean up. With the increase of running time, the log will grow into a very large file, occupy a large disk space, and the efficiency is very low when analyzing problems and reading large files. Therefore, this case uses the Logrotate tool of Linu ...

Frame introductionAccording to the Convention, first introduce the protagonists of this issue: ShardingCore A high-performance, lightweight solution for reading and writing separation of tables and databases under ef core, with zero dependency, zero learning cost and zero business code intrusionThe only fully automatic sub table and multi field ...

1. Database and SQL 1-1 introduction to database Our common mysql, SQL Server, DB2, Oracle Database and Postgresql all belong to relational database management system (RDBMS) The tables stored in the database are all sheets, which can be compared to excel data sheets. They are basically the same, just like that. 1-2 introduction to SQL The ...

The control structure of PL/pgSQL is the most important and useful part. In the actual working scenario, it is inseparable from the business processing logic. When writing PL/pgSQL, the control structure is used to operate data. The control structure supported by PL/pgSQL is almost the same as that of other languages, such as condition, loop, e ...

1. Plug in code analysis pageinspect is a very typical and simple plug-in. Most processes can be learned and reused. If you need to write a new plug-in, you can directly copy and modify the following two functions, and most of the framework code can be used directly. get_raw_page the classic process of reading a page get_raw_page only retur ...

Barman is an open-source excellent PG database backup tool based on Python, which integrates backup and recovery. It can make remote / local backup for single / multiple PG databases to enhance the security of business data and provide reliable help for DBA s to recover databases. Barman advantages It supports the backup of multiple versions ...

/******************* postgresql database test starts***********************/   --This test is based on pg database version 10.11 postgres=# select version();                            version -------------------------------------------------------------  PostgreSQL 10.11, compiled by Visual C++ build 1800, 64-bit (1 Row record) --Create a ...

Without programming, generate CRUD, add, delete, modify and check RESTful API interface based on PostgreSQL zero codereviewIn the previous article, the main functions and usage of crudapi have been introduced. crudapi 1.2.0 only supports MySQL database. In order to support more databases, the code is reconstructed and the abstract factory desig ...

Database connection description When it comes to TCP keepalive related settings, you can't avoid the topic of database connection. At present, in most use environments, database connections are long connections, that is, connections can be reused. Because the database connection is different from HTTP connection, HTTP is stateless, and the co ...