Login or register (free and only takes a few minutes) to participate in this question.You will also have access to many other tools and opportunities designed for those who have language-related jobs (or are passionate about them). Participation is free and the site has a strict confidentiality policy.
English to Spanish translations [PRO]
Tech/Engineering - Computers (general) | | English term or phrase: hard conflicts | The primary and standby nodes are in many ways loosely connected. Actions on the primary will have an effect on the standby. As a result, there is potential for negative interactions or conflicts between them. The easiest conflict to understand is performance: if a huge data load is taking place on the primary then this will generate a similar stream of WAL records on the standby, so standby queries may contend for system resources, such as I/O.
There are also additional types of conflict that can occur with Hot Standby. These conflicts are *hard conflicts* in the sense that we may need to cancel queries and in some cases disconnect sessions to resolve them. The user is provided with a number of optional ways to handle these conflicts, though we must first understand the possible reasons behind a conflict.
Access Exclusive Locks from primary node, including both explicit LOCK commands and various kinds of DDL action
Dropping tablespaces on the primary while standby queries are using those tablespaces for temporary work files (work_mem overflow)
Dropping databases on the primary while users are connected to that database on the standby.
Waiting to acquire buffer cleanup locks
Early cleanup of data still visible to the current query's snapshot |
| Jaime CastroKudoZ activityQuestions: 16 (none open) ( 1 closed without grading) Answers: 445
United States
| | Local time: 14:34
|
| | Selected response from:
Tania13
Local time: 13:34
| Grading comment Gracias.
4 KudoZ points were awarded for this answer |
| |
| Discussion entries: 0 |
|---|
Automatic update in 00:
|
4 hrs confidence:   peer agreement (net): +1
9 hrs confidence:
Return to KudoZ list
|
| | | | X Sign in to your ProZ.com account... | | | | |
| KudoZ™ translation helpThe KudoZ network provides a framework for translators and others to assist each other with translations or explanations of terms and short phrases. See also: Search millions of term translations  |
The translation workplace 
