Fwd: Re: Query is slow when run for first time; subsequent executionis fast

Поиск
Список
Период
Сортировка
От Nandakumar M
Тема Fwd: Re: Query is slow when run for first time; subsequent executionis fast
Дата
Msg-id CANcFUu5hAy6Eavx2rJdhtXh2MdXYf9SpwhL-FahhPh0hj37U5w@mail.gmail.com
обсуждение исходный текст
Ответ на Query is slow when run for first time; subsequent execution is fast  (Nandakumar M <m.nanda92@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Missed to have mailing list in to address.. forwarding now.

---------- Forwarded message ----------
From: "Nandakumar M" <m.nanda92@gmail.com>
Date: 15 Jan 2018 12:16
Subject: Re: Query is slow when run for first time; subsequent execution is fast
To: "Pavel Stehule" <pavel.stehule@gmail.com>
Cc:

Hi,

On Fri, Jan 12, 2018 at 3:34 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:

>> maybe some your indexes and some system tables are bloated. Try you run VACUUM FULL ANALYZE
 
Tried this suggestion. Planning time gets reduced slightly but it is still way higher on the first run compared to subsequent runs of the same query.

Regards,
Nanda

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

Предыдущее
От: Neto pr
Дата:
Сообщение: Re: HDD vs SSD without explanation
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Query is slow when run for first time; subsequent execution isfast