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

[Nandakumar M <m.nanda92@xxxxxxxxx>]

Missed to have mailing list in to address.. forwarding now.

---------- Forwarded message ----------
From: "Nandakumar M" <m.nanda92@xxxxxxxxx>
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@xxxxxxxxx>
Cc:

Hi,

On Fri, Jan 12, 2018 at 3:34 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> 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