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