Re: BUG #17153: tpch-hammerdb-Query21

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: BUG #17153: tpch-hammerdb-Query21
Дата
Msg-id CAApHDvoQ7QXg3EV9Qy0dS1bcKxuWr02xTNOpJewOGfeib9T=rg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17153: tpch-hammerdb-Query21  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17153: tpch-hammerdb-Query21  (anil bommareddy <anilbommareddy09@gmail.com>)
Список pgsql-bugs
On Wed, 18 Aug 2021 at 19:12, PG Bug reporting form
<noreply@postgresql.org> wrote:
> In PostgreSQL13.3 , tried to run tpch with Hammedb benchmark environment .
> Observed Q17,Q20, Q21 executed long period time .
> Q17--->5000 seconds
> Q20--->6124 seconds
> Q21--->53271 seconds.
> the issue was may not observe with pervious/older PostgreSQL version like
> 12.x

There's really not much to go on here. We'd need much more detail than
you've provided to be able to identify if there are any bugs.

How long did those queries take to run in v12?

We'd also need:
* EXPLAIN ANALYZE output for each query on each version
* postgresql.conf from each version.
* schema from each version.

David



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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: BUG #17149: About --skip option of pg_amcheck command
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #17148: About --no-strict-names option and --quiet option of pg_amcheck command