Re: Same query, same data different plan

Поиск
Список
Период
Сортировка
От Kostas Papadopoulos
Тема Re: Same query, same data different plan
Дата
Msg-id 14b38f31-452c-22d6-6a4f-bd79e2e026b5@methodosit.com.cy
обсуждение исходный текст
Ответ на Re: Same query, same data different plan  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi Adrian,

On 10/10/2022 20:59, Adrian Klaver wrote:
> Information needed:
> 
> 1) The query and its EXPLAIN ANALYZE for both slow/fast cases.
> 
> 2) Postgres version.
> 
> 3) What database are the developers workstation pointing at?
> 
> 4) What is the test db and is it the same as 3)?
> 
> 5) What clients are you using to run the query?
> 


Thanks for the interest. I was just looking for pointers on what to look at next. Got 
that from Tom (table bloat) and Imre (different random sample of analyze).

Regards
kostas



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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11
Следующее
От: gzh
Дата:
Сообщение: Re:Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11