Functions ............................................................................. 380 9.23. Merge Support Functions ..................................................................... 381 9.24. ........................................................................................... 1968 MERGE ................................................................................................. Window Functions ...................................................................... 380 9.66. Merge Support Functions ...............................................................................

Functions ................................................................................... 402 9.23. Merge Support Functions .......................................................................... 404 9 ........................................................................................... 2082 MERGE ................................................................................................. Functions ............................................................................ 403 9.66. Merge Support Functions ...............................................................................

........................................................................................... 1886 MERGE ................................................................................................. COPY TO. This privilege is also needed to reference existing column values in UPDATE, DELETE, or MERGE. For sequences, this privilege also allows use of the currval function. For large objects, this privilege it came from is marked not-null. Check constraints are merged if they have the same name, and the merge will fail if their conditions are different. Table inheritance is typically established when the

........................................................................................... 1996 MERGE ................................................................................................. COPY TO. This privilege is also needed to reference existing column values in UPDATE, DELETE, or MERGE. For sequences, this privilege also allows use of the currval function. For large objects, this privilege it came from is marked not-null. Check constraints are merged if they have the same name, and the merge will fail if their conditions are different. Table inheritance is typically established when the

........................................................................................... 1924 MERGE ................................................................................................. COPY TO. This privilege is also needed to reference existing column values in UPDATE, DELETE, or MERGE. For sequences, this privilege also allows use of the currval function. For large objects, this privilege it came from is marked not-null. Check constraints are merged if they have the same name, and the merge will fail if their conditions are different. Table inheritance is typically established when the

........................................................................................... 2035 MERGE ................................................................................................. COPY TO. This privilege is also needed to reference existing column values in UPDATE, DELETE, or MERGE. For sequences, this privilege also allows use of the currval function. For large objects, this privilege it came from is marked not-null. Check constraints are merged if they have the same name, and the merge will fail if their conditions are different. Table inheritance is typically established when the

keep this fact in mind when choosing the value. Sort operations are used for ORDER BY, DISTINCT, and merge joins. Hash tables are used in hash joins, hash-based aggregation, and hash-based processing of IN types. The default is on. enable_mergejoin (boolean) Enables or disables the query planner’s use of merge-join plan types. The default is on. enable_nestloop (boolean) Enables or disables the query planner’s on using constraint exclusion and partitioning. from_collapse_limit (integer) The planner will merge sub-queries into upper queries if the resulting FROM list would have no more than this many items

keep this fact in mind when choosing the value. Sort operations are used for ORDER BY, DISTINCT, and merge joins. Hash tables are used in hash joins, hash-based aggregation, and hash-based processing of IN types. The default is on. enable_mergejoin (boolean) Enables or disables the query planner’s use of merge-join plan types. The default is on. enable_nestloop (boolean) Enables or disables the query planner’s on using constraint exclusion and partitioning. from_collapse_limit (integer) The planner will merge sub-queries into upper queries if the resulting FROM list would have no more than this many items

scratch, the existing content of the table needs to be sorted. Allowing the merge sort to use more memory means that fewer merge passes will be required. A larger setting for maintenance_work_mem may also keep this fact in mind when choosing the value. Sort operations are used for ORDER BY, DISTINCT, and merge joins. Hash tables are used in hash joins, hash-based aggregation, and hash-based processing of IN types. The default is on. enable_mergejoin (boolean) Enables or disables the query planner’s use of merge-join plan types. The default is on. enable_nestloop (boolean) Enables or disables the query planner’s

scratch, the existing content of the table needs to be sorted. Allowing the merge sort to use more memory means that fewer merge passes will be required. A larger setting for maintenance_work_mem may also keep this fact in mind when choosing the value. Sort operations are used for ORDER BY, DISTINCT, and merge joins. Hash tables are used in hash joins, hash-based aggregation, and hash-based processing of IN types. The default is on. enable_mergejoin (boolean) Enables or disables the query planner’s use of merge-join plan types. The default is on. 246 Chapter 16. Server Run-time Environment enable_nestloop