Missed to have mailing list in to address.. forwarding now.
---------- Forwarded message ----------
From: "Nandakumar M" <m(dot)nanda92(at)gmail(dot)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(dot)stehule(at)gmail(dot)com>
Cc:
Hi,
On Fri, Jan 12, 2018 at 3:34 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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