PostgreSQL Source Code git master
Loading...
Searching...
No Matches
gininsert.c
Go to the documentation of this file.
1/*-------------------------------------------------------------------------
2 *
3 * gininsert.c
4 * insert routines for the postgres inverted index access method.
5 *
6 *
7 * Portions Copyright (c) 1996-2026, PostgreSQL Global Development Group
8 * Portions Copyright (c) 1994, Regents of the University of California
9 *
10 * IDENTIFICATION
11 * src/backend/access/gin/gininsert.c
12 *-------------------------------------------------------------------------
13 */
14
15#include "postgres.h"
16
17#include "access/gin_private.h"
18#include "access/gin_tuple.h"
19#include "access/parallel.h"
20#include "access/table.h"
21#include "access/tableam.h"
22#include "access/xloginsert.h"
23#include "catalog/index.h"
25#include "commands/progress.h"
26#include "executor/instrument.h"
27#include "miscadmin.h"
28#include "nodes/execnodes.h"
29#include "pgstat.h"
30#include "storage/bufmgr.h"
32#include "storage/proc.h"
33#include "storage/predicate.h"
34#include "tcop/tcopprot.h"
35#include "utils/datum.h"
36#include "utils/memutils.h"
37#include "utils/builtins.h"
38#include "utils/rel.h"
39#include "utils/tuplesort.h"
40#include "utils/typcache.h"
41#include "utils/wait_event.h"
42
43
44/* Magic numbers for parallel state sharing */
45#define PARALLEL_KEY_GIN_SHARED UINT64CONST(0xB000000000000001)
46#define PARALLEL_KEY_TUPLESORT UINT64CONST(0xB000000000000002)
47#define PARALLEL_KEY_QUERY_TEXT UINT64CONST(0xB000000000000003)
48#define PARALLEL_KEY_WAL_USAGE UINT64CONST(0xB000000000000004)
49#define PARALLEL_KEY_BUFFER_USAGE UINT64CONST(0xB000000000000005)
50
51/*
52 * Status for index builds performed in parallel. This is allocated in a
53 * dynamic shared memory segment.
54 */
55typedef struct GinBuildShared
56{
57 /*
58 * These fields are not modified during the build. They primarily exist
59 * for the benefit of worker processes that need to create state
60 * corresponding to that used by the leader.
61 */
66
67 /*
68 * workersdonecv is used to monitor the progress of workers. All parallel
69 * participants must indicate that they are done before leader can use
70 * results built by the workers (and before leader can write the data into
71 * the index).
72 */
74
75 /*
76 * mutex protects all following fields
77 *
78 * These fields contain status information of interest to GIN index builds
79 * that must work just the same when an index is built in parallel.
80 */
82
83 /*
84 * Mutable state that is maintained by workers, and reported back to
85 * leader at end of the scans.
86 *
87 * nparticipantsdone is number of worker processes finished.
88 *
89 * reltuples is the total number of input heap tuples.
90 *
91 * indtuples is the total number of tuples that made it into the index.
92 */
94 double reltuples;
95 double indtuples;
96
97 /*
98 * ParallelTableScanDescData data follows. Can't directly embed here, as
99 * implementations of the parallel table scan desc interface might need
100 * stronger alignment.
101 */
103
104/*
105 * Return pointer to a GinBuildShared's parallel table scan.
106 *
107 * c.f. shm_toc_allocate as to why BUFFERALIGN is used, rather than just
108 * MAXALIGN.
109 */
110#define ParallelTableScanFromGinBuildShared(shared) \
111 (ParallelTableScanDesc) ((char *) (shared) + BUFFERALIGN(sizeof(GinBuildShared)))
112
113/*
114 * Status for leader in parallel index build.
115 */
116typedef struct GinLeader
117{
118 /* parallel context itself */
120
121 /*
122 * nparticipanttuplesorts is the exact number of worker processes
123 * successfully launched, plus one leader process if it participates as a
124 * worker (only DISABLE_LEADER_PARTICIPATION builds avoid leader
125 * participating as a worker).
126 */
128
129 /*
130 * Leader process convenience pointers to shared state (leader avoids TOC
131 * lookups).
132 *
133 * GinBuildShared is the shared state for entire build. sharedsort is the
134 * shared, tuplesort-managed state passed to each process tuplesort.
135 * snapshot is the snapshot used by the scan iff an MVCC snapshot is
136 * required.
137 */
144
145typedef struct
146{
148 double indtuples;
155
156 /*
157 * bs_leader is only present when a parallel index build is performed, and
158 * only in the leader process.
159 */
161
162 /* number of participating workers (including leader) */
164
165 /* used to pass information from workers to leader */
168
169 /*
170 * The sortstate is used by workers (including the leader). It has to be
171 * part of the build state, because that's the only thing passed to the
172 * build callback etc.
173 */
175
176 /*
177 * The sortstate used only within a single worker for the first merge pass
178 * happening there. In principle it doesn't need to be part of the build
179 * state and we could pass it around directly, but it's more convenient
180 * this way. And it's part of the build state, after all.
181 */
184
185
186/* parallel index builds */
188 bool isconcurrent, int request);
194 Relation heap, Relation index);
196 GinBuildShared *ginshared,
197 Sharedsort *sharedsort,
198 Relation heap, Relation index,
199 int sortmem, bool progress);
200
203
204static GinTuple *_gin_build_tuple(OffsetNumber attrnum, unsigned char category,
205 Datum key, int16 typlen, bool typbyval,
207 Size *len);
208
209/*
210 * Adds array of item pointers to tuple's posting list, or
211 * creates posting tree and tuple pointing to tree in case
212 * of not enough space. Max size of tuple is defined in
213 * GinFormTuple(). Returns a new, modified index tuple.
214 * items[] must be in sorted order with no duplicates.
215 */
216static IndexTuple
220 GinStatsData *buildStats, Buffer buffer)
221{
223 Datum key;
224 GinNullCategory category;
225 IndexTuple res;
227 *oldItems;
228 int oldNPosting,
230 nwritten;
232
234
235 attnum = gintuple_get_attrnum(ginstate, old);
236 key = gintuple_get_key(ginstate, old, &category);
237
238 /* merge the old and new posting lists */
240
243 &newNPosting);
244
245 /* Compress the posting list, and try to a build tuple with room for it */
246 res = NULL;
248 if (nwritten == newNPosting)
249 {
250 res = GinFormTuple(ginstate, attnum, key, category,
251 (char *) compressedList,
254 false);
255 }
256
259
260 if (!res)
261 {
262 /* posting list would be too big, convert to posting tree */
264
265 /*
266 * Initialize posting tree with the old tuple's posting list. It's
267 * surely small enough to fit on one posting-tree page, and should
268 * already be in order with no duplicates.
269 */
271 oldItems,
273 buildStats,
274 buffer);
275
276 /* Now insert the TIDs-to-be-added into the posting tree */
278 items, nitem,
279 buildStats);
280
281 /* And build a new posting-tree-only result tuple */
282 res = GinFormTuple(ginstate, attnum, key, category, NULL, 0, 0, true);
284 }
286
287 return res;
288}
289
290/*
291 * Build a fresh leaf tuple, either posting-list or posting-tree format
292 * depending on whether the given items list will fit.
293 * items[] must be in sorted order with no duplicates.
294 *
295 * This is basically the same logic as in addItemPointersToLeafTuple,
296 * but working from slightly different input.
297 */
298static IndexTuple
302 GinStatsData *buildStats, Buffer buffer)
303{
304 IndexTuple res = NULL;
306 int nwritten;
307
308 /* try to build a posting list tuple with all the items */
310 if (nwritten == nitem)
311 {
312 res = GinFormTuple(ginstate, attnum, key, category,
313 (char *) compressedList,
315 nitem, false);
316 }
318
319 if (!res)
320 {
321 /* posting list would be too big, build posting tree */
323
324 /*
325 * Build posting-tree-only result tuple. We do this first so as to
326 * fail quickly if the key is too big.
327 */
328 res = GinFormTuple(ginstate, attnum, key, category, NULL, 0, 0, true);
329
330 /*
331 * Initialize a new posting tree with the TIDs.
332 */
333 postingRoot = createPostingTree(ginstate->index, items, nitem,
334 buildStats, buffer);
335
336 /* And save the root link in the result tuple */
338 }
339
340 return res;
341}
342
343/*
344 * Insert one or more heap TIDs associated with the given key value.
345 * This will either add a single key entry, or enlarge a pre-existing entry.
346 *
347 * During an index build, buildStats is non-null and the counters
348 * it contains should be incremented as needed.
349 */
350void
354 GinStatsData *buildStats)
355{
356 GinBtreeData btree;
358 GinBtreeStack *stack;
359 IndexTuple itup;
360 Page page;
361
362 insertdata.isDelete = false;
363
364 ginPrepareEntryScan(&btree, attnum, key, category, ginstate);
365 btree.isBuild = (buildStats != NULL);
366
367 stack = ginFindLeafPage(&btree, false, false);
368 page = BufferGetPage(stack->buffer);
369
370 if (btree.findItem(&btree, stack))
371 {
372 /* found pre-existing entry */
373 itup = (IndexTuple) PageGetItem(page, PageGetItemId(page, stack->off));
374
375 if (GinIsPostingTree(itup))
376 {
377 /* add entries to existing posting tree */
379
380 /* release all stack */
382 freeGinBtreeStack(stack);
383
384 /* insert into posting tree */
386 items, nitem,
387 buildStats);
388 return;
389 }
390
393 /* modify an existing leaf entry */
394 itup = addItemPointersToLeafTuple(ginstate, itup,
395 items, nitem, buildStats, stack->buffer);
396
397 insertdata.isDelete = true;
398 }
399 else
400 {
403 /* no match, so construct a new leaf entry */
404 itup = buildFreshLeafTuple(ginstate, attnum, key, category,
405 items, nitem, buildStats, stack->buffer);
406
407 /*
408 * nEntries counts leaf tuples, so increment it only when we make a
409 * new one.
410 */
411 if (buildStats)
412 buildStats->nEntries++;
413 }
414
415 /* Insert the new or modified leaf tuple */
416 insertdata.entry = itup;
417 ginInsertValue(&btree, stack, &insertdata, buildStats);
418 pfree(itup);
419}
420
421/*
422 * Extract index entries for a single indexable item, and add them to the
423 * BuildAccumulator's state.
424 *
425 * This function is used only during initial index creation.
426 */
427static void
429 Datum value, bool isNull,
431{
432 Datum *entries;
433 GinNullCategory *categories;
434 int32 nentries;
436
438 entries = ginExtractEntries(buildstate->accum.ginstate, attnum,
439 value, isNull,
440 &nentries, &categories);
442
444 entries, categories, nentries);
445
446 buildstate->indtuples += nentries;
447
449}
450
451static void
453 bool *isnull, bool tupleIsAlive, void *state)
454{
457 int i;
458
460
461 for (i = 0; i < buildstate->ginstate.origTupdesc->natts; i++)
463 values[i], isnull[i], tid);
464
465 /* If we've maxed out our available memory, dump everything to the index */
466 if (buildstate->accum.allocatedMemory >= maintenance_work_mem * (Size) 1024)
467 {
468 ItemPointerData *list;
469 Datum key;
470 GinNullCategory category;
471 uint32 nlist;
473
474 ginBeginBAScan(&buildstate->accum);
475 while ((list = ginGetBAEntry(&buildstate->accum,
476 &attnum, &key, &category, &nlist)) != NULL)
477 {
478 /* there could be many entries, so be willing to abort here */
480 ginEntryInsert(&buildstate->ginstate, attnum, key, category,
481 list, nlist, &buildstate->buildStats);
482 }
483
485 ginInitBA(&buildstate->accum);
486 }
487
489}
490
491/*
492 * ginFlushBuildState
493 * Write all data from BuildAccumulator into the tuplesort.
494 *
495 * The number of TIDs written to the tuplesort at once is limited, to reduce
496 * the amount of memory needed when merging the intermediate results later.
497 * The leader will see up to two chunks per worker, so calculate the limit to
498 * not need more than MaxAllocSize overall.
499 *
500 * We don't need to worry about overflowing maintenance_work_mem. We can't
501 * build chunks larger than work_mem, and that limit was set so that workers
502 * produce sufficiently small chunks.
503 */
504static void
506{
507 ItemPointerData *list;
508 Datum key;
509 GinNullCategory category;
510 uint32 nlist;
513 uint32 maxlen;
514
515 /* maximum number of TIDs per chunk (two chunks per worker) */
516 maxlen = MaxAllocSize / sizeof(ItemPointerData);
517 maxlen /= (2 * buildstate->bs_num_workers);
518
519 ginBeginBAScan(&buildstate->accum);
520 while ((list = ginGetBAEntry(&buildstate->accum,
521 &attnum, &key, &category, &nlist)) != NULL)
522 {
523 /* information about the key */
525
526 /* start of the chunk */
527 uint32 offset = 0;
528
529 /* split the entry into smaller chunk with up to maxlen items */
530 while (offset < nlist)
531 {
532 /* GIN tuple and tuple length */
533 GinTuple *tup;
534 Size tuplen;
535 uint32 len = Min(maxlen, nlist - offset);
536
537 /* there could be many entries, so be willing to abort here */
539
540 tup = _gin_build_tuple(attnum, category,
541 key, attr->attlen, attr->attbyval,
542 &list[offset], len,
543 &tuplen);
544
545 offset += len;
546
547 tuplesort_putgintuple(buildstate->bs_worker_sort, tup, tuplen);
548
549 pfree(tup);
550 }
551 }
552
554 ginInitBA(&buildstate->accum);
555}
556
557/*
558 * ginBuildCallbackParallel
559 * Callback for the parallel index build.
560 *
561 * This is similar to the serial build callback ginBuildCallback, but
562 * instead of writing the accumulated entries into the index, each worker
563 * writes them into a (local) tuplesort.
564 *
565 * The worker then sorts and combines these entries, before writing them
566 * into a shared tuplesort for the leader (see _gin_parallel_scan_and_build
567 * for the whole process).
568 */
569static void
571 bool *isnull, bool tupleIsAlive, void *state)
572{
575 int i;
576
578
579 /*
580 * if scan wrapped around - flush accumulated entries and start anew
581 *
582 * With parallel scans, we don't have a guarantee the scan does not start
583 * half-way through the relation (serial builds disable sync scans and
584 * always start from block 0, parallel scans require allow_sync=true).
585 *
586 * Building the posting lists assumes the TIDs are monotonic and never go
587 * back, and the wrap around would break that. We handle that by detecting
588 * the wraparound, and flushing all entries. This means we'll later see
589 * two separate entries with non-overlapping TID lists (which can be
590 * combined by merge sort).
591 *
592 * To detect a wraparound, we remember the last TID seen by each worker
593 * (for any key). If the next TID seen by the worker is lower, the scan
594 * must have wrapped around.
595 */
596 if (ItemPointerCompare(tid, &buildstate->tid) < 0)
598
599 /* remember the TID we're about to process */
600 buildstate->tid = *tid;
601
602 for (i = 0; i < buildstate->ginstate.origTupdesc->natts; i++)
604 values[i], isnull[i], tid);
605
606 /*
607 * If we've maxed out our available memory, dump everything to the
608 * tuplesort. We use half the per-worker fraction of maintenance_work_mem,
609 * the other half is used for the tuplesort.
610 */
611 if (buildstate->accum.allocatedMemory >= buildstate->work_mem * (Size) 1024)
613
615}
616
619{
620 IndexBuildResult *result;
621 double reltuples;
626 ItemPointerData *list;
627 Datum key;
628 GinNullCategory category;
629 uint32 nlist;
632
634 elog(ERROR, "index \"%s\" already contains data",
636
637 initGinState(&buildstate.ginstate, index);
638 buildstate.indtuples = 0;
639 memset(&buildstate.buildStats, 0, sizeof(GinStatsData));
640
641 /* Initialize fields for parallel build too. */
642 buildstate.bs_numtuples = 0;
643 buildstate.bs_reltuples = 0;
644 buildstate.bs_leader = NULL;
645 memset(&buildstate.tid, 0, sizeof(ItemPointerData));
646
647 /* initialize the meta page */
649
650 /* initialize the root page */
652
658
659
663
664 /* count the root as first entry page */
665 buildstate.buildStats.nEntryPages++;
666
667 /*
668 * create a temporary memory context that is used to hold data not yet
669 * dumped out to the index
670 */
672 "Gin build temporary context",
674
675 /*
676 * create a temporary memory context that is used for calling
677 * ginExtractEntries(), and can be reset after each tuple
678 */
680 "Gin build temporary context for user-defined function",
682
683 buildstate.accum.ginstate = &buildstate.ginstate;
684 ginInitBA(&buildstate.accum);
685
686 /* Report table scan phase started */
689
690 /*
691 * Attempt to launch parallel worker scan when required
692 *
693 * XXX plan_create_index_workers makes the number of workers dependent on
694 * maintenance_work_mem, requiring 32MB for each worker. For GIN that's
695 * reasonable too, because we sort the data just like btree. It does
696 * ignore the memory used to accumulate data in memory (set by work_mem),
697 * but there is no way to communicate that to plan_create_index_workers.
698 */
699 if (indexInfo->ii_ParallelWorkers > 0)
700 _gin_begin_parallel(state, heap, index, indexInfo->ii_Concurrent,
701 indexInfo->ii_ParallelWorkers);
702
703 /*
704 * If parallel build requested and at least one worker process was
705 * successfully launched, set up coordination state, wait for workers to
706 * complete. Then read all tuples from the shared tuplesort and insert
707 * them into the index.
708 *
709 * In serial mode, simply scan the table and build the index one index
710 * tuple at a time.
711 */
712 if (state->bs_leader)
713 {
715
717 coordinate->isWorker = false;
718 coordinate->nParticipants =
719 state->bs_leader->nparticipanttuplesorts;
720 coordinate->sharedsort = state->bs_leader->sharedsort;
721
722 /*
723 * Begin leader tuplesort.
724 *
725 * In cases where parallelism is involved, the leader receives the
726 * same share of maintenance_work_mem as a serial sort (it is
727 * generally treated in the same way as a serial sort once we return).
728 * Parallel worker Tuplesortstates will have received only a fraction
729 * of maintenance_work_mem, though.
730 *
731 * We rely on the lifetime of the Leader Tuplesortstate almost not
732 * overlapping with any worker Tuplesortstate's lifetime. There may
733 * be some small overlap, but that's okay because we rely on leader
734 * Tuplesortstate only allocating a small, fixed amount of memory
735 * here. When its tuplesort_performsort() is called (by our caller),
736 * and significant amounts of memory are likely to be used, all
737 * workers must have already freed almost all memory held by their
738 * Tuplesortstates (they are about to go away completely, too). The
739 * overall effect is that maintenance_work_mem always represents an
740 * absolute high watermark on the amount of memory used by a CREATE
741 * INDEX operation, regardless of the use of parallelism or any other
742 * factor.
743 */
744 state->bs_sortstate =
748
749 /* scan the relation in parallel and merge per-worker results */
750 reltuples = _gin_parallel_merge(state);
751
752 _gin_end_parallel(state->bs_leader, state);
753 }
754 else /* no parallel index build */
755 {
756 /*
757 * Do the heap scan. We disallow sync scan here because
758 * dataPlaceToPage prefers to receive tuples in TID order.
759 */
760 reltuples = table_index_build_scan(heap, index, indexInfo, false, true,
762
763 /* dump remaining entries to the index */
766 while ((list = ginGetBAEntry(&buildstate.accum,
767 &attnum, &key, &category, &nlist)) != NULL)
768 {
769 /* there could be many entries, so be willing to abort here */
771 ginEntryInsert(&buildstate.ginstate, attnum, key, category,
772 list, nlist, &buildstate.buildStats);
773 }
775 }
776
779
780 /*
781 * Update metapage stats
782 */
783 buildstate.buildStats.nTotalPages = RelationGetNumberOfBlocks(index);
784 ginUpdateStats(index, &buildstate.buildStats, true);
785
786 /*
787 * We didn't write WAL records as we built the index, so if WAL-logging is
788 * required, write all pages to the WAL now.
789 */
791 {
794 true);
795 }
796
797 /*
798 * Return statistics
799 */
801
802 result->heap_tuples = reltuples;
803 result->index_tuples = buildstate.indtuples;
804
805 return result;
806}
807
808/*
809 * ginbuildempty() -- build an empty gin index in the initialization fork
810 */
811void
813{
816
817 /* An empty GIN index has two pages. */
822
823 /* Initialize and xlog metabuffer and root buffer. */
832
833 /* Unlock and release the buffers. */
836}
837
838/*
839 * Insert index entries for a single indexable item during "normal"
840 * (non-fast-update) insertion
841 */
842static void
844 Datum value, bool isNull,
845 ItemPointer item)
846{
847 Datum *entries;
848 GinNullCategory *categories;
849 int32 i,
850 nentries;
851
852 entries = ginExtractEntries(ginstate, attnum, value, isNull,
853 &nentries, &categories);
854
855 for (i = 0; i < nentries; i++)
856 {
857 /* there could be many entries, so be willing to abort here */
859 ginEntryInsert(ginstate, attnum, entries[i], categories[i],
860 item, 1, NULL);
861 }
862}
863
864bool
868 bool indexUnchanged,
869 IndexInfo *indexInfo)
870{
871 GinState *ginstate = (GinState *) indexInfo->ii_AmCache;
874 int i;
875
876 /* Initialize GinState cache if first call in this statement */
877 if (ginstate == NULL)
878 {
880 ginstate = palloc_object(GinState);
881 initGinState(ginstate, index);
882 indexInfo->ii_AmCache = ginstate;
884 }
885
887 "Gin insert temporary context",
889
891
893 {
895
896 memset(&collector, 0, sizeof(GinTupleCollector));
897
898 for (i = 0; i < ginstate->origTupdesc->natts; i++)
900 (OffsetNumber) (i + 1),
901 values[i], isnull[i],
902 ht_ctid);
903
905 }
906 else
907 {
908 for (i = 0; i < ginstate->origTupdesc->natts; i++)
909 ginHeapTupleInsert(ginstate, (OffsetNumber) (i + 1),
910 values[i], isnull[i],
911 ht_ctid);
912 }
913
916
917 return false;
918}
919
920/*
921 * Create parallel context, and launch workers for leader.
922 *
923 * buildstate argument should be initialized (with the exception of the
924 * tuplesort states, which may later be created based on shared
925 * state initially set up here).
926 *
927 * isconcurrent indicates if operation is CREATE INDEX CONCURRENTLY.
928 *
929 * request is the target number of parallel worker processes to launch.
930 *
931 * Sets buildstate's GinLeader, which caller must use to shut down parallel
932 * mode by passing it to _gin_end_parallel() at the very end of its index
933 * build. If not even a single worker process can be launched, this is
934 * never set, and caller should proceed with a serial index build.
935 */
936static void
938 bool isconcurrent, int request)
939{
940 ParallelContext *pcxt;
941 int scantuplesortstates;
942 Snapshot snapshot;
945 GinBuildShared *ginshared;
946 Sharedsort *sharedsort;
948 WalUsage *walusage;
949 BufferUsage *bufferusage;
950 bool leaderparticipates = true;
951 int querylen;
952
953#ifdef DISABLE_LEADER_PARTICIPATION
954 leaderparticipates = false;
955#endif
956
957 /*
958 * Enter parallel mode, and create context for parallel build of gin index
959 */
961 Assert(request > 0);
962 pcxt = CreateParallelContext("postgres", "_gin_parallel_build_main",
963 request);
964
965 scantuplesortstates = leaderparticipates ? request + 1 : request;
966
967 /*
968 * Prepare for scan of the base relation. In a normal index build, we use
969 * SnapshotAny because we must retrieve all tuples and do our own time
970 * qual checks (because we have to index RECENTLY_DEAD tuples). In a
971 * concurrent build, we take a regular MVCC snapshot and index whatever's
972 * live according to that.
973 */
974 if (!isconcurrent)
975 snapshot = SnapshotAny;
976 else
978
979 /*
980 * Estimate size for our own PARALLEL_KEY_GIN_SHARED workspace.
981 */
984 estsort = tuplesort_estimate_shared(scantuplesortstates);
986
988
989 /*
990 * Estimate space for WalUsage and BufferUsage -- PARALLEL_KEY_WAL_USAGE
991 * and PARALLEL_KEY_BUFFER_USAGE.
992 *
993 * If there are no extensions loaded that care, we could skip this. We
994 * have no way of knowing whether anyone's looking at pgWalUsage or
995 * pgBufferUsage, so do it unconditionally.
996 */
998 mul_size(sizeof(WalUsage), pcxt->nworkers));
1001 mul_size(sizeof(BufferUsage), pcxt->nworkers));
1003
1004 /* Finally, estimate PARALLEL_KEY_QUERY_TEXT space */
1006 {
1010 }
1011 else
1012 querylen = 0; /* keep compiler quiet */
1013
1014 /* Everyone's had a chance to ask for space, so now create the DSM */
1016
1017 /* If no DSM segment was available, back out (do serial build) */
1018 if (pcxt->seg == NULL)
1019 {
1020 if (IsMVCCSnapshot(snapshot))
1021 UnregisterSnapshot(snapshot);
1024 return;
1025 }
1026
1027 /* Store shared build state, for which we reserved space */
1028 ginshared = (GinBuildShared *) shm_toc_allocate(pcxt->toc, estginshared);
1029 /* Initialize immutable state */
1030 ginshared->heaprelid = RelationGetRelid(heap);
1031 ginshared->indexrelid = RelationGetRelid(index);
1032 ginshared->isconcurrent = isconcurrent;
1033 ginshared->scantuplesortstates = scantuplesortstates;
1034
1036 SpinLockInit(&ginshared->mutex);
1037
1038 /* Initialize mutable state */
1039 ginshared->nparticipantsdone = 0;
1040 ginshared->reltuples = 0.0;
1041 ginshared->indtuples = 0.0;
1042
1045 snapshot);
1046
1047 /*
1048 * Store shared tuplesort-private state, for which we reserved space.
1049 * Then, initialize opaque state using tuplesort routine.
1050 */
1051 sharedsort = (Sharedsort *) shm_toc_allocate(pcxt->toc, estsort);
1052 tuplesort_initialize_shared(sharedsort, scantuplesortstates,
1053 pcxt->seg);
1054
1055 shm_toc_insert(pcxt->toc, PARALLEL_KEY_GIN_SHARED, ginshared);
1056 shm_toc_insert(pcxt->toc, PARALLEL_KEY_TUPLESORT, sharedsort);
1057
1058 /* Store query string for workers */
1060 {
1061 char *sharedquery;
1062
1063 sharedquery = (char *) shm_toc_allocate(pcxt->toc, querylen + 1);
1066 }
1067
1068 /*
1069 * Allocate space for each worker's WalUsage and BufferUsage; no need to
1070 * initialize.
1071 */
1072 walusage = shm_toc_allocate(pcxt->toc,
1073 mul_size(sizeof(WalUsage), pcxt->nworkers));
1074 shm_toc_insert(pcxt->toc, PARALLEL_KEY_WAL_USAGE, walusage);
1075 bufferusage = shm_toc_allocate(pcxt->toc,
1076 mul_size(sizeof(BufferUsage), pcxt->nworkers));
1077 shm_toc_insert(pcxt->toc, PARALLEL_KEY_BUFFER_USAGE, bufferusage);
1078
1079 /* Launch workers, saving status for leader/caller */
1081 ginleader->pcxt = pcxt;
1082 ginleader->nparticipanttuplesorts = pcxt->nworkers_launched;
1084 ginleader->nparticipanttuplesorts++;
1085 ginleader->ginshared = ginshared;
1086 ginleader->sharedsort = sharedsort;
1087 ginleader->snapshot = snapshot;
1088 ginleader->walusage = walusage;
1089 ginleader->bufferusage = bufferusage;
1090
1091 /* If no workers were successfully launched, back out (do serial build) */
1092 if (pcxt->nworkers_launched == 0)
1093 {
1095 return;
1096 }
1097
1098 /* Save leader state now that it's clear build will be parallel */
1099 buildstate->bs_leader = ginleader;
1100
1101 /* Join heap scan ourselves */
1104
1105 /*
1106 * Caller needs to wait for all launched workers when we return. Make
1107 * sure that the failure-to-start case will not hang forever.
1108 */
1110}
1111
1112/*
1113 * Shut down workers, destroy parallel context, and end parallel mode.
1114 */
1115static void
1117{
1118 int i;
1119
1120 /* Shutdown worker processes */
1122
1123 /*
1124 * Next, accumulate WAL usage. (This must wait for the workers to finish,
1125 * or we might get incomplete data.)
1126 */
1127 for (i = 0; i < ginleader->pcxt->nworkers_launched; i++)
1128 InstrAccumParallelQuery(&ginleader->bufferusage[i], &ginleader->walusage[i]);
1129
1130 /* Free last reference to MVCC snapshot, if one was used */
1131 if (IsMVCCSnapshot(ginleader->snapshot))
1132 UnregisterSnapshot(ginleader->snapshot);
1135}
1136
1137/*
1138 * Within leader, wait for end of heap scan.
1139 *
1140 * When called, parallel heap scan started by _gin_begin_parallel() will
1141 * already be underway within worker processes (when leader participates
1142 * as a worker, we should end up here just as workers are finishing).
1143 *
1144 * Returns the total number of heap tuples scanned.
1145 */
1146static double
1148{
1149 GinBuildShared *ginshared = state->bs_leader->ginshared;
1150 int nparticipanttuplesorts;
1151
1152 nparticipanttuplesorts = state->bs_leader->nparticipanttuplesorts;
1153 for (;;)
1154 {
1155 SpinLockAcquire(&ginshared->mutex);
1156 if (ginshared->nparticipantsdone == nparticipanttuplesorts)
1157 {
1158 /* copy the data into leader state */
1159 state->bs_reltuples = ginshared->reltuples;
1160 state->bs_numtuples = ginshared->indtuples;
1161
1162 SpinLockRelease(&ginshared->mutex);
1163 break;
1164 }
1165 SpinLockRelease(&ginshared->mutex);
1166
1169 }
1170
1172
1173 return state->bs_reltuples;
1174}
1175
1176/*
1177 * Buffer used to accumulate TIDs from multiple GinTuples for the same key
1178 * (we read these from the tuplesort, sorted by the key).
1179 *
1180 * This is similar to BuildAccumulator in that it's used to collect TIDs
1181 * in memory before inserting them into the index, but it's much simpler
1182 * as it only deals with a single index key at a time.
1183 *
1184 * When adding TIDs to the buffer, we make sure to keep them sorted, both
1185 * during the initial table scan (and detecting when the scan wraps around),
1186 * and during merging (where we do mergesort).
1187 */
1188typedef struct GinBuffer
1189{
1192 Datum key; /* 0 if no key (and keylen == 0) */
1193 Size keylen; /* number of bytes (not typlen) */
1194
1195 /* type info */
1198
1199 /* Number of TIDs to collect before attempt to write some out. */
1201
1202 /* array of TID values */
1205 SortSupport ssup; /* for sorting/comparing keys */
1208
1209/*
1210 * Check that TID array contains valid values, and that it's sorted (if we
1211 * expect it to be).
1212 */
1213static void
1215{
1216#ifdef USE_ASSERT_CHECKING
1217 /* we should not have a buffer with no TIDs to sort */
1218 Assert(buffer->items != NULL);
1219 Assert(buffer->nitems > 0);
1220
1221 for (int i = 0; i < buffer->nitems; i++)
1222 {
1223 Assert(ItemPointerIsValid(&buffer->items[i]));
1224
1225 /* don't check ordering for the first TID item */
1226 if (i == 0)
1227 continue;
1228
1229 Assert(ItemPointerCompare(&buffer->items[i - 1], &buffer->items[i]) < 0);
1230 }
1231#endif
1232}
1233
1234/*
1235 * GinBuffer checks
1236 *
1237 * Make sure the nitems/items fields are consistent (either the array is empty
1238 * or not empty, the fields need to agree). If there are items, check ordering.
1239 */
1240static void
1242{
1243#ifdef USE_ASSERT_CHECKING
1244 /* if we have any items, the array must exist */
1245 Assert(!((buffer->nitems > 0) && (buffer->items == NULL)));
1246
1247 /*
1248 * The buffer may be empty, in which case we must not call the check of
1249 * item pointers, because that assumes non-emptiness.
1250 */
1251 if (buffer->nitems == 0)
1252 return;
1253
1254 /* Make sure the item pointers are valid and sorted. */
1256#endif
1257}
1258
1259/*
1260 * GinBufferInit
1261 * Initialize buffer to store tuples for a GIN index.
1262 *
1263 * Initialize the buffer used to accumulate TID for a single key at a time
1264 * (we process the data sorted), so we know when we received all data for
1265 * a given key.
1266 *
1267 * Initializes sort support procedures for all index attributes.
1268 */
1269static GinBuffer *
1271{
1273 int i,
1274 nKeys;
1276
1277 /*
1278 * How many items can we fit into the memory limit? We don't want to end
1279 * with too many TIDs. and 64kB seems more than enough. But maybe this
1280 * should be tied to maintenance_work_mem or something like that?
1281 */
1282 buffer->maxitems = (64 * 1024L) / sizeof(ItemPointerData);
1283
1285
1286 buffer->ssup = palloc0_array(SortSupportData, nKeys);
1287
1288 /*
1289 * Lookup ordering operator for the index key data type, and initialize
1290 * the sort support function.
1291 */
1292 for (i = 0; i < nKeys; i++)
1293 {
1294 Oid cmpFunc;
1295 SortSupport sortKey = &buffer->ssup[i];
1297
1298 sortKey->ssup_cxt = CurrentMemoryContext;
1299 sortKey->ssup_collation = index->rd_indcollation[i];
1300
1301 if (!OidIsValid(sortKey->ssup_collation))
1302 sortKey->ssup_collation = DEFAULT_COLLATION_OID;
1303
1304 sortKey->ssup_nulls_first = false;
1305 sortKey->ssup_attno = i + 1;
1306 sortKey->abbreviate = false;
1307
1308 Assert(sortKey->ssup_attno != 0);
1309
1310 /*
1311 * If the compare proc isn't specified in the opclass definition, look
1312 * up the index key type's default btree comparator.
1313 */
1315 if (cmpFunc == InvalidOid)
1316 {
1317 TypeCacheEntry *typentry;
1318
1319 typentry = lookup_type_cache(att->atttypid,
1321 if (!OidIsValid(typentry->cmp_proc_finfo.fn_oid))
1322 ereport(ERROR,
1324 errmsg("could not identify a comparison function for type %s",
1325 format_type_be(att->atttypid))));
1326
1327 cmpFunc = typentry->cmp_proc_finfo.fn_oid;
1328 }
1329
1331 }
1332
1333 return buffer;
1334}
1335
1336/* Is the buffer empty, i.e. has no TID values in the array? */
1337static bool
1339{
1340 return (buffer->nitems == 0);
1341}
1342
1343/*
1344 * GinBufferKeyEquals
1345 * Can the buffer store TIDs for the provided GIN tuple (same key)?
1346 *
1347 * Compare if the tuple matches the already accumulated data in the GIN
1348 * buffer. Compare scalar fields first, before the actual key.
1349 *
1350 * Returns true if the key matches, and the TID belongs to the buffer, or
1351 * false if the key does not match.
1352 */
1353static bool
1355{
1356 int r;
1357 Datum tupkey;
1358
1359 AssertCheckGinBuffer(buffer);
1360
1361 if (tup->attrnum != buffer->attnum)
1362 return false;
1363
1364 /* same attribute should have the same type info */
1365 Assert(tup->typbyval == buffer->typbyval);
1366 Assert(tup->typlen == buffer->typlen);
1367
1368 if (tup->category != buffer->category)
1369 return false;
1370
1371 /*
1372 * For NULL/empty keys, this means equality, for normal keys we need to
1373 * compare the actual key value.
1374 */
1375 if (buffer->category != GIN_CAT_NORM_KEY)
1376 return true;
1377
1378 /*
1379 * For the tuple, get either the first sizeof(Datum) bytes for byval
1380 * types, or a pointer to the beginning of the data array.
1381 */
1382 tupkey = (buffer->typbyval) ? *(Datum *) tup->data : PointerGetDatum(tup->data);
1383
1384 r = ApplySortComparator(buffer->key, false,
1385 tupkey, false,
1386 &buffer->ssup[buffer->attnum - 1]);
1387
1388 return (r == 0);
1389}
1390
1391/*
1392 * GinBufferShouldTrim
1393 * Should we trim the list of item pointers?
1394 *
1395 * By trimming we understand writing out and removing the tuple IDs that
1396 * we know can't change by future merges. We can deduce the TID up to which
1397 * this is guaranteed from the "first" TID in each GIN tuple, which provides
1398 * a "horizon" (for a given key) thanks to the sort.
1399 *
1400 * We don't want to do this too often - compressing longer TID lists is more
1401 * efficient. But we also don't want to accumulate too many TIDs, for two
1402 * reasons. First, it consumes memory and we might exceed maintenance_work_mem
1403 * (or whatever limit applies), even if that's unlikely because TIDs are very
1404 * small so we can fit a lot of them. Second, and more importantly, long TID
1405 * lists are an issue if the scan wraps around, because a key may get a very
1406 * wide list (with min/max TID for that key), forcing "full" mergesorts for
1407 * every list merged into it (instead of the efficient append).
1408 *
1409 * So we look at two things when deciding if to trim - if the resulting list
1410 * (after adding TIDs from the new tuple) would be too long, and if there is
1411 * enough TIDs to trim (with values less than "first" TID from the new tuple),
1412 * we do the trim. By enough we mean at least 128 TIDs (mostly an arbitrary
1413 * number).
1414 *
1415 * We try freezing TIDs at the beginning of the list first, before attempting
1416 * to trim the buffer. This may allow trimming the data earlier, reducing the
1417 * memory usage and excluding it from the mergesort.
1418 */
1419static bool
1421{
1422 /*
1423 * Check if the last TID in the current list is frozen. This is the case
1424 * when merging non-overlapping lists, e.g. in each parallel worker.
1425 */
1426 if ((buffer->nitems > 0) &&
1427 (ItemPointerCompare(&buffer->items[buffer->nitems - 1],
1428 GinTupleGetFirst(tup)) == 0))
1429 buffer->nfrozen = buffer->nitems;
1430
1431 /*
1432 * Now find the last TID we know to be frozen, i.e. the last TID right
1433 * before the new GIN tuple.
1434 *
1435 * Start with the first not-yet-frozen tuple, and walk until we find the
1436 * first TID that's higher. If we already know the whole list is frozen
1437 * (i.e. nfrozen == nitems), this does nothing.
1438 *
1439 * XXX This might do a binary search for sufficiently long lists, but it
1440 * does not seem worth the complexity. Overlapping lists should be rare
1441 * common, TID comparisons are cheap, and we should quickly freeze most of
1442 * the list.
1443 */
1444 for (int i = buffer->nfrozen; i < buffer->nitems; i++)
1445 {
1446 /* Is the TID after the first TID of the new tuple? Can't freeze. */
1447 if (ItemPointerCompare(&buffer->items[i],
1448 GinTupleGetFirst(tup)) > 0)
1449 break;
1450
1451 buffer->nfrozen++;
1452 }
1453
1454 /* not enough TIDs to trim (1024 is somewhat arbitrary number) */
1455 if (buffer->nfrozen < 1024)
1456 return false;
1457
1458 /* no need to trim if we have not hit the memory limit yet */
1459 if ((buffer->nitems + tup->nitems) < buffer->maxitems)
1460 return false;
1461
1462 /*
1463 * OK, we have enough frozen TIDs to flush, and we have hit the memory
1464 * limit, so it's time to write it out.
1465 */
1466 return true;
1467}
1468
1469/*
1470 * GinBufferStoreTuple
1471 * Add data (especially TID list) from a GIN tuple to the buffer.
1472 *
1473 * The buffer is expected to be empty (in which case it's initialized), or
1474 * having the same key. The TID values from the tuple are combined with the
1475 * stored values using a merge sort.
1476 *
1477 * The tuples (for the same key) are expected to be sorted by first TID. But
1478 * this does not guarantee the lists do not overlap, especially in the leader,
1479 * because the workers process interleaving data. There should be no overlaps
1480 * in a single worker - it could happen when the parallel scan wraps around,
1481 * but we detect that and flush the data (see ginBuildCallbackParallel).
1482 *
1483 * By sorting the GinTuple not only by key, but also by the first TID, we make
1484 * it more less likely the lists will overlap during merge. We merge them using
1485 * mergesort, but it's cheaper to just append one list to the other.
1486 *
1487 * How often can the lists overlap? There should be no overlaps in workers,
1488 * and in the leader we can see overlaps between lists built by different
1489 * workers. But the workers merge the items as much as possible, so there
1490 * should not be too many.
1491 */
1492static void
1494{
1496 Datum key;
1497
1498 AssertCheckGinBuffer(buffer);
1499
1502
1503 /* if the buffer is empty, set the fields (and copy the key) */
1504 if (GinBufferIsEmpty(buffer))
1505 {
1506 buffer->category = tup->category;
1507 buffer->keylen = tup->keylen;
1508 buffer->attnum = tup->attrnum;
1509
1510 buffer->typlen = tup->typlen;
1511 buffer->typbyval = tup->typbyval;
1512
1513 if (tup->category == GIN_CAT_NORM_KEY)
1514 buffer->key = datumCopy(key, buffer->typbyval, buffer->typlen);
1515 else
1516 buffer->key = (Datum) 0;
1517 }
1518
1519 /* add the new TIDs into the buffer, combine using merge-sort */
1520 {
1521 int nnew;
1522 ItemPointer new;
1523
1524 /*
1525 * Resize the array - we do this first, because we'll dereference the
1526 * first unfrozen TID, which would fail if the array is NULL. We'll
1527 * still pass 0 as number of elements in that array though.
1528 */
1529 if (buffer->items == NULL)
1530 buffer->items = palloc((buffer->nitems + tup->nitems) * sizeof(ItemPointerData));
1531 else
1532 buffer->items = repalloc(buffer->items,
1533 (buffer->nitems + tup->nitems) * sizeof(ItemPointerData));
1534
1535 new = ginMergeItemPointers(&buffer->items[buffer->nfrozen], /* first unfrozen */
1536 (buffer->nitems - buffer->nfrozen), /* num of unfrozen */
1537 items, tup->nitems, &nnew);
1538
1539 Assert(nnew == (tup->nitems + (buffer->nitems - buffer->nfrozen)));
1540
1541 memcpy(&buffer->items[buffer->nfrozen], new,
1542 nnew * sizeof(ItemPointerData));
1543
1544 pfree(new);
1545
1546 buffer->nitems += tup->nitems;
1547
1549 }
1550
1551 /* free the decompressed TID list */
1552 pfree(items);
1553}
1554
1555/*
1556 * GinBufferReset
1557 * Reset the buffer into a state as if it contains no data.
1558 */
1559static void
1561{
1562 Assert(!GinBufferIsEmpty(buffer));
1563
1564 /* release byref values, do nothing for by-val ones */
1565 if ((buffer->category == GIN_CAT_NORM_KEY) && !buffer->typbyval)
1566 pfree(DatumGetPointer(buffer->key));
1567
1568 /*
1569 * Not required, but makes it more likely to trigger NULL dereference if
1570 * using the value incorrectly, etc.
1571 */
1572 buffer->key = (Datum) 0;
1573
1574 buffer->attnum = 0;
1575 buffer->category = 0;
1576 buffer->keylen = 0;
1577 buffer->nitems = 0;
1578 buffer->nfrozen = 0;
1579
1580 buffer->typlen = 0;
1581 buffer->typbyval = 0;
1582}
1583
1584/*
1585 * GinBufferTrim
1586 * Discard the "frozen" part of the TID list (which should have been
1587 * written to disk/index before this call).
1588 */
1589static void
1591{
1592 Assert((buffer->nfrozen > 0) && (buffer->nfrozen <= buffer->nitems));
1593
1594 memmove(&buffer->items[0], &buffer->items[buffer->nfrozen],
1595 sizeof(ItemPointerData) * (buffer->nitems - buffer->nfrozen));
1596
1597 buffer->nitems -= buffer->nfrozen;
1598 buffer->nfrozen = 0;
1599}
1600
1601/*
1602 * GinBufferFree
1603 * Release memory associated with the GinBuffer (including TID array).
1604 */
1605static void
1607{
1608 if (buffer->items)
1609 pfree(buffer->items);
1610
1611 /* release byref values, do nothing for by-val ones */
1612 if (!GinBufferIsEmpty(buffer) &&
1613 (buffer->category == GIN_CAT_NORM_KEY) && !buffer->typbyval)
1614 pfree(DatumGetPointer(buffer->key));
1615
1616 pfree(buffer);
1617}
1618
1619/*
1620 * GinBufferCanAddKey
1621 * Check if a given GIN tuple can be added to the current buffer.
1622 *
1623 * Returns true if the buffer is either empty or for the same index key.
1624 */
1625static bool
1627{
1628 /* empty buffer can accept data for any key */
1629 if (GinBufferIsEmpty(buffer))
1630 return true;
1631
1632 /* otherwise just data for the same key */
1633 return GinBufferKeyEquals(buffer, tup);
1634}
1635
1636/*
1637 * Within leader, wait for end of heap scan and merge per-worker results.
1638 *
1639 * After waiting for all workers to finish, merge the per-worker results into
1640 * the complete index. The results from each worker are sorted by block number
1641 * (start of the page range). While combining the per-worker results we merge
1642 * summaries for the same page range, and also fill-in empty summaries for
1643 * ranges without any tuples.
1644 *
1645 * Returns the total number of heap tuples scanned.
1646 */
1647static double
1649{
1650 GinTuple *tup;
1651 Size tuplen;
1652 double reltuples = 0;
1653 GinBuffer *buffer;
1654
1655 /* GIN tuples from workers, merged by leader */
1656 double numtuples = 0;
1657
1658 /* wait for workers to scan table and produce partial results */
1659 reltuples = _gin_parallel_heapscan(state);
1660
1661 /* Execute the sort */
1664
1665 /* do the actual sort in the leader */
1666 tuplesort_performsort(state->bs_sortstate);
1667
1668 /*
1669 * Initialize buffer to combine entries for the same key.
1670 *
1671 * The leader is allowed to use the whole maintenance_work_mem buffer to
1672 * combine data. The parallel workers already completed.
1673 */
1674 buffer = GinBufferInit(state->ginstate.index);
1675
1676 /*
1677 * Set the progress target for the next phase. Reset the block number
1678 * values set by table_index_build_scan
1679 */
1680 {
1681 const int progress_index[] = {
1686 };
1687 const int64 progress_vals[] = {
1689 state->bs_numtuples,
1690 0, 0
1691 };
1692
1694 }
1695
1696 /*
1697 * Read the GIN tuples from the shared tuplesort, sorted by category and
1698 * key. That probably gives us order matching how data is organized in the
1699 * index.
1700 *
1701 * We don't insert the GIN tuples right away, but instead accumulate as
1702 * many TIDs for the same key as possible, and then insert that at once.
1703 * This way we don't need to decompress/recompress the posting lists, etc.
1704 */
1705 while ((tup = tuplesort_getgintuple(state->bs_sortstate, &tuplen, true)) != NULL)
1706 {
1708
1710
1711 /*
1712 * If the buffer can accept the new GIN tuple, just store it there and
1713 * we're done. If it's a different key (or maybe too much data) flush
1714 * the current contents into the index first.
1715 */
1716 if (!GinBufferCanAddKey(buffer, tup))
1717 {
1718 /*
1719 * Buffer is not empty and it's storing a different key - flush
1720 * the data into the insert, and start a new entry for current
1721 * GinTuple.
1722 */
1724
1726
1727 ginEntryInsert(&state->ginstate,
1728 buffer->attnum, buffer->key, buffer->category,
1729 buffer->items, buffer->nitems, &state->buildStats);
1730
1732 MemoryContextReset(state->tmpCtx);
1733
1734 /* discard the existing data */
1735 GinBufferReset(buffer);
1736 }
1737
1738 /*
1739 * We're about to add a GIN tuple to the buffer - check the memory
1740 * limit first, and maybe write out some of the data into the index
1741 * first, if needed (and possible). We only flush the part of the TID
1742 * list that we know won't change, and only if there's enough data for
1743 * compression to work well.
1744 */
1745 if (GinBufferShouldTrim(buffer, tup))
1746 {
1747 Assert(buffer->nfrozen > 0);
1748
1749 /*
1750 * Buffer is not empty and it's storing a different key - flush
1751 * the data into the insert, and start a new entry for current
1752 * GinTuple.
1753 */
1755
1757
1758 ginEntryInsert(&state->ginstate,
1759 buffer->attnum, buffer->key, buffer->category,
1760 buffer->items, buffer->nfrozen, &state->buildStats);
1761
1763 MemoryContextReset(state->tmpCtx);
1764
1765 /* truncate the data we've just discarded */
1766 GinBufferTrim(buffer);
1767 }
1768
1769 /*
1770 * Remember data for the current tuple (either remember the new key,
1771 * or append if to the existing data).
1772 */
1773 GinBufferStoreTuple(buffer, tup);
1774
1775 /* Report progress */
1777 ++numtuples);
1778 }
1779
1780 /* flush data remaining in the buffer (for the last key) */
1781 if (!GinBufferIsEmpty(buffer))
1782 {
1784
1785 ginEntryInsert(&state->ginstate,
1786 buffer->attnum, buffer->key, buffer->category,
1787 buffer->items, buffer->nitems, &state->buildStats);
1788
1789 /* discard the existing data */
1790 GinBufferReset(buffer);
1791
1792 /* Report progress */
1794 ++numtuples);
1795 }
1796
1797 /* release all the memory */
1798 GinBufferFree(buffer);
1799
1800 tuplesort_end(state->bs_sortstate);
1801
1802 return reltuples;
1803}
1804
1805/*
1806 * Returns size of shared memory required to store state for a parallel
1807 * gin index build based on the snapshot its parallel scan will use.
1808 */
1809static Size
1811{
1812 /* c.f. shm_toc_allocate as to why BUFFERALIGN is used */
1813 return add_size(BUFFERALIGN(sizeof(GinBuildShared)),
1814 table_parallelscan_estimate(heap, snapshot));
1815}
1816
1817/*
1818 * Within leader, participate as a parallel worker.
1819 */
1820static void
1822{
1823 GinLeader *ginleader = buildstate->bs_leader;
1824 int sortmem;
1825
1826 /*
1827 * Might as well use reliable figure when doling out maintenance_work_mem
1828 * (when requested number of workers were not launched, this will be
1829 * somewhat higher than it is for other workers).
1830 */
1832
1833 /* Perform work common to all participants */
1835 ginleader->sharedsort, heap, index,
1836 sortmem, true);
1837}
1838
1839/*
1840 * _gin_process_worker_data
1841 * First phase of the key merging, happening in the worker.
1842 *
1843 * Depending on the number of distinct keys, the TID lists produced by the
1844 * callback may be very short (due to frequent evictions in the callback).
1845 * But combining many tiny lists is expensive, so we try to do as much as
1846 * possible in the workers and only then pass the results to the leader.
1847 *
1848 * We read the tuples sorted by the key, and merge them into larger lists.
1849 * At the moment there's no memory limit, so this will just produce one
1850 * huge (sorted) list per key in each worker. Which means the leader will
1851 * do a very limited number of mergesorts, which is good.
1852 */
1853static void
1855 bool progress)
1856{
1857 GinTuple *tup;
1858 Size tuplen;
1859
1860 GinBuffer *buffer;
1861
1862 /*
1863 * Initialize buffer to combine entries for the same key.
1864 *
1865 * The workers are limited to the same amount of memory as during the sort
1866 * in ginBuildCallbackParallel. But this probably should be the 32MB used
1867 * during planning, just like there.
1868 */
1869 buffer = GinBufferInit(state->ginstate.index);
1870
1871 /* sort the raw per-worker data */
1872 if (progress)
1875
1876 tuplesort_performsort(state->bs_worker_sort);
1877
1878 /* reset the number of GIN tuples produced by this worker */
1879 state->bs_numtuples = 0;
1880
1881 if (progress)
1884
1885 /*
1886 * Read the GIN tuples from the shared tuplesort, sorted by the key, and
1887 * merge them into larger chunks for the leader to combine.
1888 */
1889 while ((tup = tuplesort_getgintuple(worker_sort, &tuplen, true)) != NULL)
1890 {
1891
1893
1894 /*
1895 * If the buffer can accept the new GIN tuple, just store it there and
1896 * we're done. If it's a different key (or maybe too much data) flush
1897 * the current contents into the index first.
1898 */
1899 if (!GinBufferCanAddKey(buffer, tup))
1900 {
1901 GinTuple *ntup;
1902 Size ntuplen;
1903
1904 /*
1905 * Buffer is not empty and it's storing a different key - flush
1906 * the data into the insert, and start a new entry for current
1907 * GinTuple.
1908 */
1910
1911 ntup = _gin_build_tuple(buffer->attnum, buffer->category,
1912 buffer->key, buffer->typlen, buffer->typbyval,
1913 buffer->items, buffer->nitems, &ntuplen);
1914
1915 tuplesort_putgintuple(state->bs_sortstate, ntup, ntuplen);
1916 state->bs_numtuples++;
1917
1918 pfree(ntup);
1919
1920 /* discard the existing data */
1921 GinBufferReset(buffer);
1922 }
1923
1924 /*
1925 * We're about to add a GIN tuple to the buffer - check the memory
1926 * limit first, and maybe write out some of the data into the index
1927 * first, if needed (and possible). We only flush the part of the TID
1928 * list that we know won't change, and only if there's enough data for
1929 * compression to work well.
1930 */
1931 if (GinBufferShouldTrim(buffer, tup))
1932 {
1933 GinTuple *ntup;
1934 Size ntuplen;
1935
1936 Assert(buffer->nfrozen > 0);
1937
1938 /*
1939 * Buffer is not empty and it's storing a different key - flush
1940 * the data into the insert, and start a new entry for current
1941 * GinTuple.
1942 */
1944
1945 ntup = _gin_build_tuple(buffer->attnum, buffer->category,
1946 buffer->key, buffer->typlen, buffer->typbyval,
1947 buffer->items, buffer->nfrozen, &ntuplen);
1948
1949 tuplesort_putgintuple(state->bs_sortstate, ntup, ntuplen);
1950
1951 pfree(ntup);
1952
1953 /* truncate the data we've just discarded */
1954 GinBufferTrim(buffer);
1955 }
1956
1957 /*
1958 * Remember data for the current tuple (either remember the new key,
1959 * or append if to the existing data).
1960 */
1961 GinBufferStoreTuple(buffer, tup);
1962 }
1963
1964 /* flush data remaining in the buffer (for the last key) */
1965 if (!GinBufferIsEmpty(buffer))
1966 {
1967 GinTuple *ntup;
1968 Size ntuplen;
1969
1971
1972 ntup = _gin_build_tuple(buffer->attnum, buffer->category,
1973 buffer->key, buffer->typlen, buffer->typbyval,
1974 buffer->items, buffer->nitems, &ntuplen);
1975
1976 tuplesort_putgintuple(state->bs_sortstate, ntup, ntuplen);
1977 state->bs_numtuples++;
1978
1979 pfree(ntup);
1980
1981 /* discard the existing data */
1982 GinBufferReset(buffer);
1983 }
1984
1985 /* release all the memory */
1986 GinBufferFree(buffer);
1987
1989}
1990
1991/*
1992 * Perform a worker's portion of a parallel GIN index build sort.
1993 *
1994 * This generates a tuplesort for the worker portion of the table.
1995 *
1996 * sortmem is the amount of working memory to use within each worker,
1997 * expressed in KBs.
1998 *
1999 * When this returns, workers are done, and need only release resources.
2000 *
2001 * Before feeding data into a shared tuplesort (for the leader process),
2002 * the workers process data in two phases.
2003 *
2004 * 1) A worker reads a portion of rows from the table, accumulates entries
2005 * in memory, and flushes them into a private tuplesort (e.g. because of
2006 * using too much memory).
2007 *
2008 * 2) The private tuplesort gets sorted (by key and TID), the worker reads
2009 * the data again, and combines the entries as much as possible. This has
2010 * to happen eventually, and this way it's done in workers in parallel.
2011 *
2012 * Finally, the combined entries are written into the shared tuplesort, so
2013 * that the leader can process them.
2014 *
2015 * How well this works (compared to just writing entries into the shared
2016 * tuplesort) depends on the data set. For large tables with many distinct
2017 * keys this helps a lot. With many distinct keys it's likely the buffers has
2018 * to be flushed often, generating many entries with the same key and short
2019 * TID lists. These entries need to be sorted and merged at some point,
2020 * before writing them to the index. The merging is quite expensive, it can
2021 * easily be ~50% of a serial build, and doing as much of it in the workers
2022 * means it's parallelized. The leader still has to merge results from the
2023 * workers, but it's much more efficient to merge few large entries than
2024 * many tiny ones.
2025 *
2026 * This also reduces the amount of data the workers pass to the leader through
2027 * the shared tuplesort. OTOH the workers need more space for the private sort,
2028 * possibly up to 2x of the data, if no entries be merged in a worker. But this
2029 * is very unlikely, and the only consequence is inefficiency, so we ignore it.
2030 */
2031static void
2033 GinBuildShared *ginshared, Sharedsort *sharedsort,
2034 Relation heap, Relation index,
2035 int sortmem, bool progress)
2036{
2038 TableScanDesc scan;
2039 double reltuples;
2040 IndexInfo *indexInfo;
2041
2042 /* Initialize local tuplesort coordination state */
2044 coordinate->isWorker = true;
2045 coordinate->nParticipants = -1;
2046 coordinate->sharedsort = sharedsort;
2047
2048 /* remember how much space is allowed for the accumulated entries */
2049 state->work_mem = (sortmem / 2);
2050
2051 /* remember how many workers participate in the build */
2052 state->bs_num_workers = ginshared->scantuplesortstates;
2053
2054 /* Begin "partial" tuplesort */
2055 state->bs_sortstate = tuplesort_begin_index_gin(heap, index,
2056 state->work_mem,
2057 coordinate,
2059
2060 /* Local per-worker sort of raw-data */
2061 state->bs_worker_sort = tuplesort_begin_index_gin(heap, index,
2062 state->work_mem,
2063 NULL,
2065
2066 /* Join parallel scan */
2067 indexInfo = BuildIndexInfo(index);
2068 indexInfo->ii_Concurrent = ginshared->isconcurrent;
2069
2070 scan = table_beginscan_parallel(heap,
2072
2073 reltuples = table_index_build_scan(heap, index, indexInfo, true, progress,
2075
2076 /* write remaining accumulated entries */
2078
2079 /*
2080 * Do the first phase of in-worker processing - sort the data produced by
2081 * the callback, and combine them into much larger chunks and place that
2082 * into the shared tuplestore for leader to process.
2083 */
2084 _gin_process_worker_data(state, state->bs_worker_sort, progress);
2085
2086 /* sort the GIN tuples built by this worker */
2087 tuplesort_performsort(state->bs_sortstate);
2088
2089 state->bs_reltuples += reltuples;
2090
2091 /*
2092 * Done. Record ambuild statistics.
2093 */
2094 SpinLockAcquire(&ginshared->mutex);
2095 ginshared->nparticipantsdone++;
2096 ginshared->reltuples += state->bs_reltuples;
2097 ginshared->indtuples += state->bs_numtuples;
2098 SpinLockRelease(&ginshared->mutex);
2099
2100 /* Notify leader */
2102
2103 tuplesort_end(state->bs_sortstate);
2104}
2105
2106/*
2107 * Perform work within a launched parallel process.
2108 */
2109void
2111{
2112 char *sharedquery;
2113 GinBuildShared *ginshared;
2114 Sharedsort *sharedsort;
2116 Relation heapRel;
2117 Relation indexRel;
2120 WalUsage *walusage;
2121 BufferUsage *bufferusage;
2122 int sortmem;
2123
2124 /*
2125 * The only possible status flag that can be set to the parallel worker is
2126 * PROC_IN_SAFE_IC.
2127 */
2128 Assert((MyProc->statusFlags == 0) ||
2130
2131 /* Set debug_query_string for individual workers first */
2134
2135 /* Report the query string from leader */
2137
2138 /* Look up gin shared state */
2139 ginshared = shm_toc_lookup(toc, PARALLEL_KEY_GIN_SHARED, false);
2140
2141 /* Open relations using lock modes known to be obtained by index.c */
2142 if (!ginshared->isconcurrent)
2143 {
2146 }
2147 else
2148 {
2151 }
2152
2153 /* Open relations within worker */
2154 heapRel = table_open(ginshared->heaprelid, heapLockmode);
2155 indexRel = index_open(ginshared->indexrelid, indexLockmode);
2156
2157 /* initialize the GIN build state */
2158 initGinState(&buildstate.ginstate, indexRel);
2159 buildstate.indtuples = 0;
2160 memset(&buildstate.buildStats, 0, sizeof(GinStatsData));
2161 memset(&buildstate.tid, 0, sizeof(ItemPointerData));
2162
2163 /*
2164 * create a temporary memory context that is used to hold data not yet
2165 * dumped out to the index
2166 */
2168 "Gin build temporary context",
2170
2171 /*
2172 * create a temporary memory context that is used for calling
2173 * ginExtractEntries(), and can be reset after each tuple
2174 */
2176 "Gin build temporary context for user-defined function",
2178
2179 buildstate.accum.ginstate = &buildstate.ginstate;
2180 ginInitBA(&buildstate.accum);
2181
2182
2183 /* Look up shared state private to tuplesort.c */
2184 sharedsort = shm_toc_lookup(toc, PARALLEL_KEY_TUPLESORT, false);
2185 tuplesort_attach_shared(sharedsort, seg);
2186
2187 /* Prepare to track buffer usage during parallel execution */
2189
2190 /*
2191 * Might as well use reliable figure when doling out maintenance_work_mem
2192 * (when requested number of workers were not launched, this will be
2193 * somewhat higher than it is for other workers).
2194 */
2196
2197 _gin_parallel_scan_and_build(&buildstate, ginshared, sharedsort,
2198 heapRel, indexRel, sortmem, false);
2199
2200 /* Report WAL/buffer usage during parallel execution */
2201 bufferusage = shm_toc_lookup(toc, PARALLEL_KEY_BUFFER_USAGE, false);
2202 walusage = shm_toc_lookup(toc, PARALLEL_KEY_WAL_USAGE, false);
2204 &walusage[ParallelWorkerNumber]);
2205
2206 index_close(indexRel, indexLockmode);
2207 table_close(heapRel, heapLockmode);
2208}
2209
2210/*
2211 * Used to keep track of compressed TID lists when building a GIN tuple.
2212 */
2213typedef struct
2214{
2215 dlist_node node; /* linked list pointers */
2218
2219/*
2220 * _gin_build_tuple
2221 * Serialize the state for an index key into a tuple for tuplesort.
2222 *
2223 * The tuple has a number of scalar fields (mostly matching the build state),
2224 * and then a data array that stores the key first, and then the TID list.
2225 *
2226 * For by-reference data types, we store the actual data. For by-val types
2227 * we simply copy the whole Datum, so that we don't have to care about stuff
2228 * like endianness etc. We could make it a little bit smaller, but it's not
2229 * worth it - it's a tiny fraction of the data, and we need to MAXALIGN the
2230 * start of the TID list anyway. So we wouldn't save anything. (This would
2231 * not be a good idea for the permanent in-index data, since we'd prefer
2232 * that that not depend on sizeof(Datum). But this is just a transient
2233 * representation to use while sorting the data.)
2234 *
2235 * The TID list is serialized as compressed - it's highly compressible, and
2236 * we already have ginCompressPostingList for this purpose. The list may be
2237 * pretty long, so we compress it into multiple segments and then copy all
2238 * of that into the GIN tuple.
2239 */
2240static GinTuple *
2241_gin_build_tuple(OffsetNumber attrnum, unsigned char category,
2242 Datum key, int16 typlen, bool typbyval,
2244 Size *len)
2245{
2246 GinTuple *tuple;
2247 char *ptr;
2248
2249 Size tuplen;
2250 int keylen;
2251
2252 dlist_mutable_iter iter;
2253 dlist_head segments;
2254 int ncompressed;
2256
2257 /*
2258 * Calculate how long is the key value. Only keys with GIN_CAT_NORM_KEY
2259 * have actual non-empty key. We include varlena headers and \0 bytes for
2260 * strings, to make it easier to access the data in-line.
2261 *
2262 * For byval types we simply copy the whole Datum. We could store just the
2263 * necessary bytes, but this is simpler to work with and not worth the
2264 * extra complexity. Moreover we still need to do the MAXALIGN to allow
2265 * direct access to items pointers.
2266 *
2267 * XXX Note that for byval types we store the whole datum, no matter what
2268 * the typlen value is.
2269 */
2270 if (category != GIN_CAT_NORM_KEY)
2271 keylen = 0;
2272 else if (typbyval)
2273 keylen = sizeof(Datum);
2274 else if (typlen > 0)
2275 keylen = typlen;
2276 else if (typlen == -1)
2277 keylen = VARSIZE_ANY(DatumGetPointer(key));
2278 else if (typlen == -2)
2279 keylen = strlen(DatumGetPointer(key)) + 1;
2280 else
2281 elog(ERROR, "unexpected typlen value (%d)", typlen);
2282
2283 /* compress the item pointers */
2284 ncompressed = 0;
2285 compresslen = 0;
2286 dlist_init(&segments);
2287
2288 /* generate compressed segments of TID list chunks */
2289 while (ncompressed < nitems)
2290 {
2291 int cnt;
2293
2295 (nitems - ncompressed),
2296 UINT16_MAX,
2297 &cnt);
2298
2299 ncompressed += cnt;
2301
2302 dlist_push_tail(&segments, &seginfo->node);
2303 }
2304
2305 /*
2306 * Determine GIN tuple length with all the data included. Be careful about
2307 * alignment, to allow direct access to compressed segments (those require
2308 * only SHORTALIGN).
2309 */
2310 tuplen = SHORTALIGN(offsetof(GinTuple, data) + keylen) + compresslen;
2311
2312 *len = tuplen;
2313
2314 /*
2315 * Allocate space for the whole GIN tuple.
2316 *
2317 * The palloc0 is needed - writetup_index_gin will write the whole tuple
2318 * to disk, so we need to make sure the padding bytes are defined
2319 * (otherwise valgrind would report this).
2320 */
2321 tuple = palloc0(tuplen);
2322
2323 tuple->tuplen = tuplen;
2324 tuple->attrnum = attrnum;
2325 tuple->category = category;
2326 tuple->keylen = keylen;
2327 tuple->nitems = nitems;
2328
2329 /* key type info */
2330 tuple->typlen = typlen;
2331 tuple->typbyval = typbyval;
2332
2333 /*
2334 * Copy the key and items into the tuple. First the key value, which we
2335 * can simply copy right at the beginning of the data array.
2336 */
2337 if (category == GIN_CAT_NORM_KEY)
2338 {
2339 if (typbyval)
2340 {
2341 memcpy(tuple->data, &key, sizeof(Datum));
2342 }
2343 else if (typlen > 0) /* byref, fixed length */
2344 {
2345 memcpy(tuple->data, DatumGetPointer(key), typlen);
2346 }
2347 else if (typlen == -1)
2348 {
2349 memcpy(tuple->data, DatumGetPointer(key), keylen);
2350 }
2351 else if (typlen == -2)
2352 {
2353 memcpy(tuple->data, DatumGetPointer(key), keylen);
2354 }
2355 }
2356
2357 /* finally, copy the TIDs into the array */
2358 ptr = (char *) tuple + SHORTALIGN(offsetof(GinTuple, data) + keylen);
2359
2360 /* copy in the compressed data, and free the segments */
2361 dlist_foreach_modify(iter, &segments)
2362 {
2364
2365 memcpy(ptr, seginfo->seg, SizeOfGinPostingList(seginfo->seg));
2366
2367 ptr += SizeOfGinPostingList(seginfo->seg);
2368
2369 dlist_delete(&seginfo->node);
2370
2371 pfree(seginfo->seg);
2372 pfree(seginfo);
2373 }
2374
2375 return tuple;
2376}
2377
2378/*
2379 * _gin_parse_tuple_key
2380 * Return a Datum representing the key stored in the tuple.
2381 *
2382 * Most of the tuple fields are directly accessible, the only thing that
2383 * needs more care is the key and the TID list.
2384 *
2385 * For the key, this returns a regular Datum representing it. It's either the
2386 * actual key value, or a pointer to the beginning of the data array (which is
2387 * where the data was copied by _gin_build_tuple).
2388 */
2389static Datum
2391{
2392 Datum key;
2393
2394 if (a->category != GIN_CAT_NORM_KEY)
2395 return (Datum) 0;
2396
2397 if (a->typbyval)
2398 {
2399 memcpy(&key, a->data, a->keylen);
2400 return key;
2401 }
2402
2403 return PointerGetDatum(a->data);
2404}
2405
2406/*
2407* _gin_parse_tuple_items
2408 * Return a pointer to a palloc'd array of decompressed TID array.
2409 */
2410static ItemPointer
2412{
2413 int len;
2414 char *ptr;
2415 int ndecoded;
2417
2418 len = a->tuplen - SHORTALIGN(offsetof(GinTuple, data) + a->keylen);
2419 ptr = (char *) a + SHORTALIGN(offsetof(GinTuple, data) + a->keylen);
2420
2422
2423 Assert(ndecoded == a->nitems);
2424
2425 return items;
2426}
2427
2428/*
2429 * _gin_compare_tuples
2430 * Compare GIN tuples, used by tuplesort during parallel index build.
2431 *
2432 * The scalar fields (attrnum, category) are compared first, the key value is
2433 * compared last. The comparisons are done using type-specific sort support
2434 * functions.
2435 *
2436 * If the key value matches, we compare the first TID value in the TID list,
2437 * which means the tuples are merged in an order in which they are most
2438 * likely to be simply concatenated. (This "first" TID will also allow us
2439 * to determine a point up to which the list is fully determined and can be
2440 * written into the index to enforce a memory limit etc.)
2441 */
2442int
2444{
2445 int r;
2446 Datum keya,
2447 keyb;
2448
2449 if (a->attrnum < b->attrnum)
2450 return -1;
2451
2452 if (a->attrnum > b->attrnum)
2453 return 1;
2454
2455 if (a->category < b->category)
2456 return -1;
2457
2458 if (a->category > b->category)
2459 return 1;
2460
2461 if (a->category == GIN_CAT_NORM_KEY)
2462 {
2465
2466 r = ApplySortComparator(keya, false,
2467 keyb, false,
2468 &ssup[a->attrnum - 1]);
2469
2470 /* if the key is the same, consider the first TID in the array */
2471 return (r != 0) ? r : ItemPointerCompare(GinTupleGetFirst(a),
2473 }
2474
2477}
int ParallelWorkerNumber
Definition parallel.c:117
void InitializeParallelDSM(ParallelContext *pcxt)
Definition parallel.c:213
void WaitForParallelWorkersToFinish(ParallelContext *pcxt)
Definition parallel.c:805
void LaunchParallelWorkers(ParallelContext *pcxt)
Definition parallel.c:583
void DestroyParallelContext(ParallelContext *pcxt)
Definition parallel.c:959
ParallelContext * CreateParallelContext(const char *library_name, const char *function_name, int nworkers)
Definition parallel.c:175
void WaitForParallelWorkersToAttach(ParallelContext *pcxt)
Definition parallel.c:702
void pgstat_progress_update_param(int index, int64 val)
void pgstat_progress_update_multi_param(int nparam, const int *index, const int64 *val)
void pgstat_report_activity(BackendState state, const char *cmd_str)
@ STATE_RUNNING
uint32 BlockNumber
Definition block.h:31
static Datum values[MAXATTR]
Definition bootstrap.c:188
int Buffer
Definition buf.h:23
BlockNumber BufferGetBlockNumber(Buffer buffer)
Definition bufmgr.c:4357
Buffer ExtendBufferedRel(BufferManagerRelation bmr, ForkNumber forkNum, BufferAccessStrategy strategy, uint32 flags)
Definition bufmgr.c:974
void UnlockReleaseBuffer(Buffer buffer)
Definition bufmgr.c:5522
void MarkBufferDirty(Buffer buffer)
Definition bufmgr.c:3063
#define RelationGetNumberOfBlocks(reln)
Definition bufmgr.h:307
static Page BufferGetPage(Buffer buffer)
Definition bufmgr.h:470
static void LockBuffer(Buffer buffer, BufferLockMode mode)
Definition bufmgr.h:332
@ EB_SKIP_EXTENSION_LOCK
Definition bufmgr.h:75
@ EB_LOCK_FIRST
Definition bufmgr.h:87
#define BMR_REL(p_rel)
Definition bufmgr.h:114
static ItemId PageGetItemId(Page page, OffsetNumber offsetNumber)
Definition bufpage.h:269
static void * PageGetItem(PageData *page, const ItemIdData *itemId)
Definition bufpage.h:379
PageData * Page
Definition bufpage.h:81
#define Min(x, y)
Definition c.h:1093
#define BUFFERALIGN(LEN)
Definition c.h:900
#define Assert(condition)
Definition c.h:945
int64_t int64
Definition c.h:615
int16_t int16
Definition c.h:613
#define SHORTALIGN(LEN)
Definition c.h:894
int32_t int32
Definition c.h:614
uint32_t uint32
Definition c.h:618
#define OidIsValid(objectId)
Definition c.h:860
size_t Size
Definition c.h:691
bool ConditionVariableCancelSleep(void)
void ConditionVariableInit(ConditionVariable *cv)
void ConditionVariableSleep(ConditionVariable *cv, uint32 wait_event_info)
void ConditionVariableSignal(ConditionVariable *cv)
Datum datumCopy(Datum value, bool typByVal, int typLen)
Definition datum.c:132
int errcode(int sqlerrcode)
Definition elog.c:874
#define ERROR
Definition elog.h:39
#define elog(elevel,...)
Definition elog.h:226
#define ereport(elevel,...)
Definition elog.h:150
#define palloc_object(type)
Definition fe_memutils.h:74
#define MaxAllocSize
Definition fe_memutils.h:22
#define palloc0_array(type, count)
Definition fe_memutils.h:77
#define palloc0_object(type)
Definition fe_memutils.h:75
char * format_type_be(Oid type_oid)
IndexUniqueCheck
Definition genam.h:124
#define GIN_COMPARE_PROC
Definition gin.h:24
#define PROGRESS_GIN_PHASE_PERFORMSORT_2
Definition gin.h:49
#define PROGRESS_GIN_PHASE_MERGE_1
Definition gin.h:48
#define PROGRESS_GIN_PHASE_PERFORMSORT_1
Definition gin.h:47
#define PROGRESS_GIN_PHASE_MERGE_2
Definition gin.h:50
#define PROGRESS_GIN_PHASE_INDEXBUILD_TABLESCAN
Definition gin.h:46
#define GIN_UNLOCK
Definition gin_private.h:51
#define GinGetUseFastUpdate(relation)
Definition gin_private.h:36
static ItemPointer GinTupleGetFirst(GinTuple *tup)
Definition gin_tuple.h:35
#define GinIsPostingTree(itup)
Definition ginblock.h:231
#define GIN_CAT_NORM_KEY
Definition ginblock.h:208
#define SizeOfGinPostingList(plist)
Definition ginblock.h:342
#define GIN_LEAF
Definition ginblock.h:42
#define GinGetPostingTree(itup)
Definition ginblock.h:233
signed char GinNullCategory
Definition ginblock.h:206
#define GinSetPostingTree(itup, blkno)
Definition ginblock.h:232
#define GinMaxItemSize
Definition ginblock.h:248
void freeGinBtreeStack(GinBtreeStack *stack)
Definition ginbtree.c:198
void ginInsertValue(GinBtree btree, GinBtreeStack *stack, void *insertdata, GinStatsData *buildStats)
Definition ginbtree.c:816
GinBtreeStack * ginFindLeafPage(GinBtree btree, bool searchMode, bool rootConflictCheck)
Definition ginbtree.c:83
void ginBeginBAScan(BuildAccumulator *accum)
Definition ginbulk.c:256
ItemPointerData * ginGetBAEntry(BuildAccumulator *accum, OffsetNumber *attnum, Datum *key, GinNullCategory *category, uint32 *n)
Definition ginbulk.c:267
void ginInsertBAEntries(BuildAccumulator *accum, ItemPointer heapptr, OffsetNumber attnum, Datum *entries, GinNullCategory *categories, int32 nentries)
Definition ginbulk.c:209
void ginInitBA(BuildAccumulator *accum)
Definition ginbulk.c:109
BlockNumber createPostingTree(Relation index, ItemPointerData *items, uint32 nitems, GinStatsData *buildStats, Buffer entrybuffer)
void ginInsertItemPointers(Relation index, BlockNumber rootBlkno, ItemPointerData *items, uint32 nitem, GinStatsData *buildStats)
ItemPointer ginReadTuple(GinState *ginstate, OffsetNumber attnum, IndexTuple itup, int *nitems)
IndexTuple GinFormTuple(GinState *ginstate, OffsetNumber attnum, Datum key, GinNullCategory category, Pointer data, Size dataSize, int nipd, bool errorTooBig)
void ginPrepareEntryScan(GinBtree btree, OffsetNumber attnum, Datum key, GinNullCategory category, GinState *ginstate)
void ginHeapTupleFastCollect(GinState *ginstate, GinTupleCollector *collector, OffsetNumber attnum, Datum value, bool isNull, ItemPointer ht_ctid)
Definition ginfast.c:483
void ginHeapTupleFastInsert(GinState *ginstate, GinTupleCollector *collector)
Definition ginfast.c:219
static void ginBuildCallbackParallel(Relation index, ItemPointer tid, Datum *values, bool *isnull, bool tupleIsAlive, void *state)
Definition gininsert.c:570
#define PARALLEL_KEY_BUFFER_USAGE
Definition gininsert.c:49
static void AssertCheckItemPointers(GinBuffer *buffer)
Definition gininsert.c:1214
int _gin_compare_tuples(GinTuple *a, GinTuple *b, SortSupport ssup)
Definition gininsert.c:2443
static IndexTuple addItemPointersToLeafTuple(GinState *ginstate, IndexTuple old, ItemPointerData *items, uint32 nitem, GinStatsData *buildStats, Buffer buffer)
Definition gininsert.c:217
static bool GinBufferIsEmpty(GinBuffer *buffer)
Definition gininsert.c:1338
#define PARALLEL_KEY_GIN_SHARED
Definition gininsert.c:45
IndexBuildResult * ginbuild(Relation heap, Relation index, IndexInfo *indexInfo)
Definition gininsert.c:618
static GinBuffer * GinBufferInit(Relation index)
Definition gininsert.c:1270
static IndexTuple buildFreshLeafTuple(GinState *ginstate, OffsetNumber attnum, Datum key, GinNullCategory category, ItemPointerData *items, uint32 nitem, GinStatsData *buildStats, Buffer buffer)
Definition gininsert.c:299
static void GinBufferReset(GinBuffer *buffer)
Definition gininsert.c:1560
static void ginHeapTupleBulkInsert(GinBuildState *buildstate, OffsetNumber attnum, Datum value, bool isNull, ItemPointer heapptr)
Definition gininsert.c:428
static void AssertCheckGinBuffer(GinBuffer *buffer)
Definition gininsert.c:1241
static void _gin_parallel_scan_and_build(GinBuildState *state, GinBuildShared *ginshared, Sharedsort *sharedsort, Relation heap, Relation index, int sortmem, bool progress)
Definition gininsert.c:2032
void ginEntryInsert(GinState *ginstate, OffsetNumber attnum, Datum key, GinNullCategory category, ItemPointerData *items, uint32 nitem, GinStatsData *buildStats)
Definition gininsert.c:351
static void GinBufferTrim(GinBuffer *buffer)
Definition gininsert.c:1590
static Size _gin_parallel_estimate_shared(Relation heap, Snapshot snapshot)
Definition gininsert.c:1810
static void _gin_end_parallel(GinLeader *ginleader, GinBuildState *state)
Definition gininsert.c:1116
static void _gin_begin_parallel(GinBuildState *buildstate, Relation heap, Relation index, bool isconcurrent, int request)
Definition gininsert.c:937
static void ginFlushBuildState(GinBuildState *buildstate, Relation index)
Definition gininsert.c:505
static void _gin_process_worker_data(GinBuildState *state, Tuplesortstate *worker_sort, bool progress)
Definition gininsert.c:1854
static bool GinBufferKeyEquals(GinBuffer *buffer, GinTuple *tup)
Definition gininsert.c:1354
static double _gin_parallel_merge(GinBuildState *state)
Definition gininsert.c:1648
static void ginHeapTupleInsert(GinState *ginstate, OffsetNumber attnum, Datum value, bool isNull, ItemPointer item)
Definition gininsert.c:843
static bool GinBufferCanAddKey(GinBuffer *buffer, GinTuple *tup)
Definition gininsert.c:1626
void _gin_parallel_build_main(dsm_segment *seg, shm_toc *toc)
Definition gininsert.c:2110
void ginbuildempty(Relation index)
Definition gininsert.c:812
bool gininsert(Relation index, Datum *values, bool *isnull, ItemPointer ht_ctid, Relation heapRel, IndexUniqueCheck checkUnique, bool indexUnchanged, IndexInfo *indexInfo)
Definition gininsert.c:865
static void _gin_leader_participate_as_worker(GinBuildState *buildstate, Relation heap, Relation index)
Definition gininsert.c:1821
static GinTuple * _gin_build_tuple(OffsetNumber attrnum, unsigned char category, Datum key, int16 typlen, bool typbyval, ItemPointerData *items, uint32 nitems, Size *len)
Definition gininsert.c:2241
static Datum _gin_parse_tuple_key(GinTuple *a)
Definition gininsert.c:2390
#define PARALLEL_KEY_TUPLESORT
Definition gininsert.c:46
static bool GinBufferShouldTrim(GinBuffer *buffer, GinTuple *tup)
Definition gininsert.c:1420
#define PARALLEL_KEY_QUERY_TEXT
Definition gininsert.c:47
static void GinBufferFree(GinBuffer *buffer)
Definition gininsert.c:1606
static ItemPointer _gin_parse_tuple_items(GinTuple *a)
Definition gininsert.c:2411
#define ParallelTableScanFromGinBuildShared(shared)
Definition gininsert.c:110
#define PARALLEL_KEY_WAL_USAGE
Definition gininsert.c:48
static void GinBufferStoreTuple(GinBuffer *buffer, GinTuple *tup)
Definition gininsert.c:1493
static void ginBuildCallback(Relation index, ItemPointer tid, Datum *values, bool *isnull, bool tupleIsAlive, void *state)
Definition gininsert.c:452
static double _gin_parallel_heapscan(GinBuildState *state)
Definition gininsert.c:1147
ItemPointer ginPostingListDecodeAllSegments(GinPostingList *segment, int len, int *ndecoded_out)
GinPostingList * ginCompressPostingList(const ItemPointerData *ipd, int nipd, int maxsize, int *nwritten)
ItemPointer ginMergeItemPointers(ItemPointerData *a, uint32 na, ItemPointerData *b, uint32 nb, int *nmerged)
OffsetNumber gintuple_get_attrnum(GinState *ginstate, IndexTuple tuple)
Definition ginutil.c:233
Buffer GinNewBuffer(Relation index)
Definition ginutil.c:307
void GinInitBuffer(Buffer b, uint32 f)
Definition ginutil.c:357
Datum * ginExtractEntries(GinState *ginstate, OffsetNumber attnum, Datum value, bool isNull, int32 *nentries, GinNullCategory **categories)
Definition ginutil.c:452
Datum gintuple_get_key(GinState *ginstate, IndexTuple tuple, GinNullCategory *category)
Definition ginutil.c:266
void GinInitMetabuffer(Buffer b)
Definition ginutil.c:363
void initGinState(GinState *state, Relation index)
Definition ginutil.c:103
void ginUpdateStats(Relation index, const GinStatsData *stats, bool is_build)
Definition ginutil.c:619
int maintenance_work_mem
Definition globals.c:133
static void dlist_init(dlist_head *head)
Definition ilist.h:314
static void dlist_delete(dlist_node *node)
Definition ilist.h:405
#define dlist_foreach_modify(iter, lhead)
Definition ilist.h:640
static void dlist_push_tail(dlist_head *head, dlist_node *node)
Definition ilist.h:364
#define dlist_container(type, membername, ptr)
Definition ilist.h:593
#define nitems(x)
Definition indent.h:31
IndexInfo * BuildIndexInfo(Relation index)
Definition index.c:2429
void index_close(Relation relation, LOCKMODE lockmode)
Definition indexam.c:177
RegProcedure index_getprocid(Relation irel, AttrNumber attnum, uint16 procnum)
Definition indexam.c:883
Relation index_open(Oid relationId, LOCKMODE lockmode)
Definition indexam.c:133
static struct @174 value
void InstrAccumParallelQuery(BufferUsage *bufusage, WalUsage *walusage)
Definition instrument.c:219
void InstrEndParallelQuery(BufferUsage *bufusage, WalUsage *walusage)
Definition instrument.c:209
void InstrStartParallelQuery(void)
Definition instrument.c:201
int b
Definition isn.c:74
int a
Definition isn.c:73
int i
Definition isn.c:77
int32 ItemPointerCompare(const ItemPointerData *arg1, const ItemPointerData *arg2)
Definition itemptr.c:51
static bool ItemPointerIsValid(const ItemPointerData *pointer)
Definition itemptr.h:83
IndexTupleData * IndexTuple
Definition itup.h:53
int LOCKMODE
Definition lockdefs.h:26
#define AccessExclusiveLock
Definition lockdefs.h:43
#define ShareUpdateExclusiveLock
Definition lockdefs.h:39
#define ShareLock
Definition lockdefs.h:40
#define RowExclusiveLock
Definition lockdefs.h:38
void MemoryContextReset(MemoryContext context)
Definition mcxt.c:403
void * repalloc(void *pointer, Size size)
Definition mcxt.c:1632
void pfree(void *pointer)
Definition mcxt.c:1616
void * palloc0(Size size)
Definition mcxt.c:1417
void * palloc(Size size)
Definition mcxt.c:1387
MemoryContext CurrentMemoryContext
Definition mcxt.c:160
void MemoryContextDelete(MemoryContext context)
Definition mcxt.c:472
#define AllocSetContextCreate
Definition memutils.h:129
#define ALLOCSET_DEFAULT_SIZES
Definition memutils.h:160
#define START_CRIT_SECTION()
Definition miscadmin.h:150
#define CHECK_FOR_INTERRUPTS()
Definition miscadmin.h:123
#define END_CRIT_SECTION()
Definition miscadmin.h:152
static char * errmsg
uint16 OffsetNumber
Definition off.h:24
static MemoryContext MemoryContextSwitchTo(MemoryContext context)
Definition palloc.h:124
int16 attnum
FormData_pg_attribute * Form_pg_attribute
const void size_t len
const void * data
static int progress
Definition pgbench.c:262
const char * debug_query_string
Definition postgres.c:91
static Datum PointerGetDatum(const void *X)
Definition postgres.h:342
uint64_t Datum
Definition postgres.h:70
static Pointer DatumGetPointer(Datum X)
Definition postgres.h:332
#define InvalidOid
unsigned int Oid
void CheckForSerializableConflictIn(Relation relation, const ItemPointerData *tid, BlockNumber blkno)
Definition predicate.c:4345
static int fb(int x)
#define PROC_IN_SAFE_IC
Definition proc.h:60
#define PROGRESS_CREATEIDX_TUPLES_TOTAL
Definition progress.h:112
#define PROGRESS_SCAN_BLOCKS_DONE
Definition progress.h:148
#define PROGRESS_CREATEIDX_TUPLES_DONE
Definition progress.h:113
#define PROGRESS_CREATEIDX_SUBPHASE
Definition progress.h:111
#define PROGRESS_SCAN_BLOCKS_TOTAL
Definition progress.h:147
#define RelationGetRelid(relation)
Definition rel.h:514
#define RelationGetDescr(relation)
Definition rel.h:540
#define RelationGetRelationName(relation)
Definition rel.h:548
#define RelationNeedsWAL(relation)
Definition rel.h:637
#define IndexRelationGetNumberOfKeyAttributes(relation)
Definition rel.h:533
@ MAIN_FORKNUM
Definition relpath.h:58
@ INIT_FORKNUM
Definition relpath.h:61
void * shm_toc_allocate(shm_toc *toc, Size nbytes)
Definition shm_toc.c:88
void shm_toc_insert(shm_toc *toc, uint64 key, void *address)
Definition shm_toc.c:171
void * shm_toc_lookup(shm_toc *toc, uint64 key, bool noError)
Definition shm_toc.c:232
#define shm_toc_estimate_chunk(e, sz)
Definition shm_toc.h:51
#define shm_toc_estimate_keys(e, cnt)
Definition shm_toc.h:53
Size add_size(Size s1, Size s2)
Definition shmem.c:485
Size mul_size(Size s1, Size s2)
Definition shmem.c:500
Snapshot GetTransactionSnapshot(void)
Definition snapmgr.c:272
void UnregisterSnapshot(Snapshot snapshot)
Definition snapmgr.c:866
Snapshot RegisterSnapshot(Snapshot snapshot)
Definition snapmgr.c:824
#define SnapshotAny
Definition snapmgr.h:33
#define IsMVCCSnapshot(snapshot)
Definition snapmgr.h:59
void PrepareSortSupportComparisonShim(Oid cmpFunc, SortSupport ssup)
Definition sortsupport.c:68
static int ApplySortComparator(Datum datum1, bool isNull1, Datum datum2, bool isNull2, SortSupport ssup)
static void SpinLockRelease(volatile slock_t *lock)
Definition spin.h:62
static void SpinLockAcquire(volatile slock_t *lock)
Definition spin.h:56
static void SpinLockInit(volatile slock_t *lock)
Definition spin.h:50
PGPROC * MyProc
Definition proc.c:68
Oid fn_oid
Definition fmgr.h:59
bool(* findItem)(GinBtree, GinBtreeStack *)
OffsetNumber off
Size keylen
Definition gininsert.c:1193
GinNullCategory category
Definition gininsert.c:1191
OffsetNumber attnum
Definition gininsert.c:1190
Datum key
Definition gininsert.c:1192
SortSupport ssup
Definition gininsert.c:1205
ItemPointerData * items
Definition gininsert.c:1206
int16 typlen
Definition gininsert.c:1196
bool typbyval
Definition gininsert.c:1197
double reltuples
Definition gininsert.c:94
int scantuplesortstates
Definition gininsert.c:65
double indtuples
Definition gininsert.c:95
bool isconcurrent
Definition gininsert.c:64
slock_t mutex
Definition gininsert.c:81
ConditionVariable workersdonecv
Definition gininsert.c:73
int nparticipantsdone
Definition gininsert.c:93
double indtuples
Definition gininsert.c:148
GinState ginstate
Definition gininsert.c:147
double bs_reltuples
Definition gininsert.c:167
MemoryContext tmpCtx
Definition gininsert.c:150
GinLeader * bs_leader
Definition gininsert.c:160
GinStatsData buildStats
Definition gininsert.c:149
Tuplesortstate * bs_worker_sort
Definition gininsert.c:182
ItemPointerData tid
Definition gininsert.c:153
double bs_numtuples
Definition gininsert.c:166
Tuplesortstate * bs_sortstate
Definition gininsert.c:174
MemoryContext funcCtx
Definition gininsert.c:151
BuildAccumulator accum
Definition gininsert.c:152
Sharedsort * sharedsort
Definition gininsert.c:139
int nparticipanttuplesorts
Definition gininsert.c:127
ParallelContext * pcxt
Definition gininsert.c:119
BufferUsage * bufferusage
Definition gininsert.c:142
Snapshot snapshot
Definition gininsert.c:140
GinBuildShared * ginshared
Definition gininsert.c:138
WalUsage * walusage
Definition gininsert.c:141
dlist_node node
Definition gininsert.c:2215
GinPostingList * seg
Definition gininsert.c:2216
TupleDesc origTupdesc
Definition gin_private.h:75
Relation index
Definition gin_private.h:61
int64 nEntries
Definition gin.h:61
char data[FLEXIBLE_ARRAY_MEMBER]
Definition gin_tuple.h:31
int nitems
Definition gin_tuple.h:30
int16 typlen
Definition gin_tuple.h:27
bool typbyval
Definition gin_tuple.h:28
signed char category
Definition gin_tuple.h:29
int tuplen
Definition gin_tuple.h:24
uint16 keylen
Definition gin_tuple.h:26
OffsetNumber attrnum
Definition gin_tuple.h:25
double heap_tuples
Definition genam.h:40
double index_tuples
Definition genam.h:41
void * ii_AmCache
Definition execnodes.h:234
int ii_ParallelWorkers
Definition execnodes.h:229
bool ii_Concurrent
Definition execnodes.h:221
MemoryContext ii_Context
Definition execnodes.h:237
uint8 statusFlags
Definition proc.h:207
dsm_segment * seg
Definition parallel.h:44
shm_toc_estimator estimator
Definition parallel.h:43
shm_toc * toc
Definition parallel.h:46
int nworkers_launched
Definition parallel.h:39
FmgrInfo cmp_proc_finfo
Definition typcache.h:77
dlist_node * cur
Definition ilist.h:200
Definition type.h:96
void table_close(Relation relation, LOCKMODE lockmode)
Definition table.c:126
Relation table_open(Oid relationId, LOCKMODE lockmode)
Definition table.c:40
TableScanDesc table_beginscan_parallel(Relation relation, ParallelTableScanDesc pscan)
Definition tableam.c:166
Size table_parallelscan_estimate(Relation rel, Snapshot snapshot)
Definition tableam.c:131
void table_parallelscan_initialize(Relation rel, ParallelTableScanDesc pscan, Snapshot snapshot)
Definition tableam.c:146
static double table_index_build_scan(Relation table_rel, Relation index_rel, IndexInfo *index_info, bool allow_sync, bool progress, IndexBuildCallback callback, void *callback_state, TableScanDesc scan)
Definition tableam.h:1765
static ItemArray items
static FormData_pg_attribute * TupleDescAttr(TupleDesc tupdesc, int i)
Definition tupdesc.h:178
static CompactAttribute * TupleDescCompactAttr(TupleDesc tupdesc, int i)
Definition tupdesc.h:193
void tuplesort_performsort(Tuplesortstate *state)
Definition tuplesort.c:1259
void tuplesort_initialize_shared(Sharedsort *shared, int nWorkers, dsm_segment *seg)
Definition tuplesort.c:3210
Size tuplesort_estimate_shared(int nWorkers)
Definition tuplesort.c:3189
void tuplesort_end(Tuplesortstate *state)
Definition tuplesort.c:847
void tuplesort_attach_shared(Sharedsort *shared, dsm_segment *seg)
Definition tuplesort.c:3233
#define TUPLESORT_NONE
Definition tuplesort.h:67
Tuplesortstate * tuplesort_begin_index_gin(Relation heapRel, Relation indexRel, int workMem, SortCoordinate coordinate, int sortopt)
GinTuple * tuplesort_getgintuple(Tuplesortstate *state, Size *len, bool forward)
void tuplesort_putgintuple(Tuplesortstate *state, GinTuple *tuple, Size size)
TypeCacheEntry * lookup_type_cache(Oid type_id, int flags)
Definition typcache.c:389
#define TYPECACHE_CMP_PROC_FINFO
Definition typcache.h:144
static Size VARSIZE_ANY(const void *PTR)
Definition varatt.h:460
void ExitParallelMode(void)
Definition xact.c:1066
void EnterParallelMode(void)
Definition xact.c:1053
void log_newpage_range(Relation rel, ForkNumber forknum, BlockNumber startblk, BlockNumber endblk, bool page_std)
XLogRecPtr log_newpage_buffer(Buffer buffer, bool page_std)