select_parallel test fails with nonstandard block size

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема select_parallel test fails with nonstandard block size
Дата
Msg-id 90634e20-097a-e4fd-67d5-fb2c42f0dd71@2ndquadrant.com
обсуждение исходный текст
Ответы Re: select_parallel test fails with nonstandard block size  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
When building with --with-blocksize=16, the select_parallel test fails
with this difference:
explain (costs off)       select  sum(parallel_restricted(unique1)) from tenk1       group
by(parallel_restricted(unique1));
-                     QUERY PLAN
-----------------------------------------------------
+                QUERY PLAN
+------------------------------------------- HashAggregate   Group Key: parallel_restricted(unique1)
-   ->  Index Only Scan using tenk1_unique1 on tenk1
-(3 rows)
+   ->  Gather
+         Workers Planned: 4
+         ->  Parallel Seq Scan on tenk1
+(5 rows)
set force_parallel_mode=1;explain (costs off)

We know that different block sizes cause some test failures, mainly
because of row ordering differences.  But this looked a bit different.

The size of the tenk1 table is very similar under either block size:

16k: tenk1 = 2883584
8k:  tenk1 = 2932736

Is there an explanation for this difference, or is there something wrong
in the cost estimation somewhere?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: OpenSSL 1.1 breaks configure and more
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: sequences and pg_upgrade