Missed to have mailing list in to address.. forwarding now. ---------- Forwarded message ---------- From: "Nandakumar M" <[email protected]> Date: 15 Jan 2018 12:16 Subject: Re: Query is slow when run for first time; subsequent execution is fast To: "Pavel Stehule" <[email protected]> Cc:
Hi, On Fri, Jan 12, 2018 at 3:34 PM, Pavel Stehule <[email protected]> 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
