The case when AsyncAppend exists also in the qual of Async ForeignScan

Поиск
Список
Период
Сортировка
Искать
От
Andrey Lepikhov
Тема
The case when AsyncAppend exists also in the qual of Async ForeignScan
Дата
Msg-id
fe5eaa19-1704-e4a4-76ee-3b9d37ade399@postgrespro.ru
Список
Дерево обсуждения
The case when AsyncAppend exists also in the qual of Async ForeignScan Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan Etsuro Fujita <etsuro.fujita@gmail.com>
Re: The case when AsyncAppend exists also in the qual of Async ForeignScan "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
Hi,

I found one bug. Look at the case:

CREATE TABLE test (x int) PARTITION BY HASH (x);
CREATE TABLE test_1 (x int);
CREATE TABLE test_2 (x int);
CREATE FOREIGN TABLE ftest_1 PARTITION OF test
	FOR VALUES WITH (modulus 2, remainder 0)
	SERVER loopback OPTIONS (table_name 'test_1');
CREATE FOREIGN TABLE ftest_2 PARTITION OF test
	FOR VALUES WITH (modulus 2, remainder 1)
	SERVER loopback2 OPTIONS (table_name 'test_2');
INSERT INTO test (SELECT * FROM generate_series(1,10));
ANALYZE test,test_1,test_2,ftest_1,ftest_2;

EXPLAIN (ANALYZE)
SELECT * FROM test WHERE x NOT IN (
	SELECT avg(x) FROM test WHERE x > 10
);
ERROR:  InstrEndLoop called on running node

When I added ', COSTS OFF, SUMMARY OFF, TIMING OFF' this example fall 
down into the SEGFAULT.

I prepared quick fix for this problem (see patch in attachment). Maybe 
it is'nt a best solution but it can speedup search of it.

-- 
regards,
Andrey Lepikhov
Postgres Professional
В списке pgsql-bugs по дате отправления
От: Martin Butter
Дата:
От: Tom Lane
Дата:
FAQ