File tree Expand file tree Collapse file tree 2 files changed +11
-7
lines changed Expand file tree Collapse file tree 2 files changed +11
-7
lines changed Original file line number Diff line number Diff line change 10
10
# Caution: you may need to use GNU awk.
11
11
AWK=${AWK:- awk}
12
12
13
- TMP=" /tmp/$$ "
13
+ TMP=" ${TMPDIR:-/ tmp} /make_oidjoins_check.$$ "
14
+ trap " rm -rf $TMP " 0 1 2 3 15
14
15
15
16
# Create a temporary directory with the proper permissions so no one can
16
17
# intercept our temporary files and cause a security breach.
23
24
umask " $OMASK "
24
25
unset OMASK
25
26
26
- trap " rm -rf $TMP " 0 1 2 3 15
27
-
28
27
INPUTFILE=" $TMP /a"
29
28
DUPSFILE=" $TMP /b"
30
29
NONDUPSFILE=" $TMP /c"
Original file line number Diff line number Diff line change @@ -250,12 +250,17 @@ Indexes
250
250
order. Another method would be to sort heap ctids matching the index
251
251
before accessing the heap rows.
252
252
253
- * Use bitmaps to combine existing indexes [performance]
253
+ * Allow the creation of bitmap indexes which can be quickly combined
254
+ with other bitmap indexes
254
255
255
- Bitmap indexes allow single indexed columns to be combined to
256
- dynamically create a composite index to match a specific query. Each
257
- index is a bitmap, and the bitmaps are AND'ed or OR'ed to be combined.
256
+ Bitmap indexes index single columns and can be combined with other bitmap
257
+ indexes to dynamically create a composite index to match a specific query.
258
+ Each index is a bitmap, and the bitmaps are bitwise AND'ed or OR'ed to be
259
+ combined.
258
260
261
+ * Allow non-bitmap indexes to be combined
262
+
263
+ Do loUse bitmaps to combine non-bitmap indexes
259
264
* Allow use of indexes to search for NULLs
260
265
261
266
One solution is to create a partial index on an IS NULL expression.
You can’t perform that action at this time.
0 commit comments