Postgres Pro
Downloads
Home   >   mailing lists

Re: Query is slow when run for first time; subsequent execution isfast - Mailing list pgsql-performance

From Thomas Kellerer
Subject Re: Query is slow when run for first time; subsequent execution isfast
Date
Msg-id d46ddd88-6eaf-33a0-0b7b-672b5316262e@gmx.net
Whole thread Raw
In response to Re: Query is slow when run for first time; subsequent execution is fast  (Nandakumar M <m.nanda92@gmail.com>)
List pgsql-performance
Tree view 
Nandakumar M schrieb am 12.01.2018 um 09:03:
> Even if I close a connection and open a new one and execute the same
> query, the planning time is considerably less than the first time.
> Only when I restart the Postgres server then I face high planning
> time again.

Yes, because the data is cached by Postgres ("shared_buffers") and the filesystem.

pgsql-performance by date:

Previous
From: Nandakumar M
Date:
Subject: Fwd: Re: Query is slow when run for first time; subsequent executionis fast
Next
From: Nicolas Charles
Date:
Subject: Re: HDD vs SSD without explanation