PostgreSQL 16.1 DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) TABLESPACE fasttablespace; (Recall that adjacent partitions can share a bound value, since ---------------------- ------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 2974 页 | 14.22 MB | 1 年前3
PostgreSQL 17beta1 A4 DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) TABLESPACE fasttablespace; (Recall that adjacent partitions can share a bound value, since ---------------------- ------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 3017 页 | 14.45 MB | 1 年前3
PostgreSQL 16.1 DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) TABLESPACE fasttablespace; (Recall that adjacent partitions can share a bound value, since ---------------------- ------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 3133 页 | 14.10 MB | 1 年前3
PostgreSQL 17beta1 US DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) TABLESPACE fasttablespace; (Recall that adjacent partitions can share a bound value, since ---------------------- ------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 3188 页 | 14.32 MB | 1 年前3
PostgreSQL 13.13 DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) TABLESPACE fasttablespace; (Recall that adjacent partitions can share a bound value, since ---------------------- ------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 2782 页 | 13.00 MB | 1 年前3
PostgreSQL 13.14 DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) 99 Data Definition TABLESPACE fasttablespace; (Recall that adjacent partitions can share ---------------------- ------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 2940 页 | 12.89 MB | 1 年前3
PostgreSQL 14.10 DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) TABLESPACE fasttablespace; (Recall that adjacent partitions can share a bound value, since ---------------------- ------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 2871 页 | 13.38 MB | 1 年前3
PostgreSQL 14.10 DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) TABLESPACE fasttablespace; (Recall that adjacent partitions can share a bound value, since ---------------------- ------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 3032 页 | 13.27 MB | 1 年前3
PostgreSQL 11.22 Documentationmeasurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') 90 Data Definition WITH (parallel_workers = 4) TABLESPACE fasttablespace; (Recall that adjacent partitions can share a bound value, since ----------------------------------------- Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 2732 页 | 12.44 MB | 1 年前3
PostgreSQL 11.22 DocumentationPARTITION OF measurement FOR VALUES FROM ('2008-01-01') TO ('2008-02-01') WITH (parallel_workers = 4) 96 Data Definition TABLESPACE fasttablespace; (Recall that adjacent partitions can share ----------------------------------------- Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 -> Parallel Seq Scan on pgbench_accounts (cost=0.00..216018.33 rows=1 width=97) is a child of the Gather node, it will run in parallel. Using EXPLAIN, you can see the number of workers chosen by the planner. When the Gather node is reached during query execution, the process that is0 码力 | 2883 页 | 12.34 MB | 1 年前3
共 91 条
- 1
- 2
- 3
- 4
- 5
- 6
- 10













