Programmer Think

Abstract: GaussDB(DWS) provides two cluster level views to quickly identify and query lock waiting and distributed deadlock information, which can locate and analyze the second level problems of this kind of problems. This article is shared from Huawei cloud community< GaussDB(DWS) operation and maintenance -- one click lock waiting and d ...

function flow ExecScan ExecScanFetch IndexNext[Top level loop function] [1]index_beginscan: (scandesc = index_beginscan generate scandesc (yes) index_beginscan_internal[getr] btbeginscan: initialization IndexScanDesc and BTScanOpaque IndexScanDesc scan = ... BTScanOpaque so = ... ...

version: postgresql10.17 0 summary summary leaf page If the level 0 page (the bottom page) has a right brother, the first one is the first one of the right brothers (it should be the last one on this page. Note that this one does not belong to this page, but the smallest one on the next page is worth copying). Note: the leftmost page of ...

📢📢📢📣📣📣 Hello! Hello, I'm [IT bond], known as jeames007 in Jianghu, with 10 years of DBA working experience A highly motivated [big data blogger]! 😜😜😜 Member of China DBA Alliance (ACDU), currently engaged in DBA and program programming, lecturer in station B and Tencent classroom, with a live broadcast volume of more than 10W Good at m ...

This chapter will introduce the school data model and the operation of the school data model table. 1.4 school data model 1.4.1 about this experiment Taking the school database model as an example, this paper introduces the openGauss database, tables, tablespaces, users and other objects, as well as the use of SQL syntax. Suppose that school ...

background With the continuous expansion of data volume, the strengthening of analysis demand and the process of localization, the original traditional database can no longer support and complete heavy tasks. More and more data warehouses and data Lake platforms are migrating to MPP, big data and cloud original platforms. However, in thi ...

1, Background introduction The maximum number of connections of PostgreSQL will become a problem that annoys the business at some time. The number of business connections has soared, and the number of connections is full, but the service cannot be restarted. This scenario is very embarrassing. The maximum number of connections can only be rest ...

1. Error Key Information Caused by: org.postgresql.util.PSQLException: ERROR: column "c1" is of type point but expression is of type character at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) at org.postgres ...

1. Parent child inheritance tableAt present, MogDB does not support inherits inheritance feature.omm=# CREATE TABLE tab_t2(age int) inherits(tab_t1); ERROR: CREATE TABLE ... INHERITS is not yet supported.PostgreSQL supports inheritance. Partitioned tables before version 10 are implemented through inheritance. Each partition is actually an inde ...

Today is the first day of the Gregorian new year in 2022. I wish you a happy New Year's day. This is also the first article in 2022. Later, I will bring you more articles about Doris. At the same time, I hope Doris will take off in 2022, graduate smoothly from Apache incubator into a top-level project, and bring you a faster, more stable and mo ...