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 ...
Posted by hanhao on Thu, 10 Mar 2022 19:05:13 +0100
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 ...
Posted by _off_axis_ on Thu, 10 Mar 2022 03:53:49 +0100
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 ...
Posted by oneofayykind on Tue, 08 Mar 2022 03:46:52 +0100
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
Posted by Hylian on Mon, 07 Mar 2022 14:00:22 +0100
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 ...
Posted by rea|and on Sat, 05 Mar 2022 04:26:03 +0100
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 ...
Posted by lrsdsout on Tue, 01 Mar 2022 16:50:55 +0100
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.
It supports the backup of multiple versions ...
Posted by snakebit on Mon, 28 Feb 2022 15:40:54 +0100
/******************* postgresql database test starts***********************/
--This test is based on pg database version 10.11
postgres=# select version();
PostgreSQL 10.11, compiled by Visual C++ build 1800, 64-bit
(1 Row record)
--Create a ...
Posted by engelsol on Wed, 23 Feb 2022 15:21:50 +0100
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 ...
Posted by snoopgreen on Wed, 23 Feb 2022 06:51:06 +0100
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 ...
Posted by chemoautotroph on Tue, 22 Feb 2022 10:54:46 +0100