Re: Query optimization advice for beginners

Поиск
Список
Период
Сортировка
От Kemal Ortanca
Тема Re: Query optimization advice for beginners
Дата
Msg-id AM0PR03MB4211A876D473A21406ECBE6EF80B0@AM0PR03MB4211.eurprd03.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Query optimization advice for beginners  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-performance
Дерево обсуждения
Firstly, thank you for coming back.

PostgreSQL version = 11.5

Is there a resource or postgresql configuration you want me to check in addition?


From: Andreas Kretschmer <andreas@a-kretschmer.de>
Sent: Monday, January 27, 2020 3:57 PM
To: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: Query optimization advice for beginners
 


Am 27.01.20 um 14:15 schrieb Kemal Ortanca:
>
> https://explain.depesz.com/s/G4vq
>
>

the estimates and the real values are very different, seems like
problems with autoanalyze.

which version?



Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



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

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Query optimization advice for beginners
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Query optimization advice for beginners