Re: Query taking long time

Поиск
Список
Период
Сортировка
От Venkata Balaji Nagothi
Тема Re: Query taking long time
Дата
Msg-id CAHBAh5sX72X68R+guufShz4mJBMiv9oMVzc3-VNYyp6+sDioZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query taking long time  ("acanada" <acanada@cnio.es>)
Список pgsql-performance
Дерево обсуждения

On Thu, Mar 20, 2014 at 9:17 PM, acanada <acanada@cnio.es> wrote:
Hello,

New server postgres version is 9.3. I'm not sure if I collected latest statistics after migration, if you mean if the current_settings or analyze queries that I posted were collected after migration... yes (notice that there are analyze query before migration and after migration, maybe I didn't illustrate right)
Sorry for that. Reading the statistics collector manual, I see there are plenty of parameters, and I'm not sure which one of them are you interested in, or if there's a query to collect them...

Hi Andres,

If we do not have statistics, its hard to arrive at any conclusion regarding performance. The cost numbers we get without statistics are not accurate.

Also, you have migrated across 5 major versions since 8.3. It is very important to have latest statistics in place.

Please perform VACUUM FULL and ANALYZE of the database.

Please post the EXPLAIN plan after that.

Thanks & Regards,

Venkata Balaji N
Fujitsu Australia

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

Предыдущее
От: bricklen
Дата:
Сообщение: Re: Suboptimal query plan when using expensive BCRYPT functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Suboptimal query plan when using expensive BCRYPT functions