Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Proposal : For Auto-Prewarm. - Mailing list pgsql-hackers

From Mithun Cy
Subject Re: [HACKERS] Proposal : For Auto-Prewarm.
Date
Msg-id CAD__OugHoWdW=xLfv_AgwmrcSAMWO_gS2D8YDFFAhJt=GsvTYw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Proposal : For Auto-Prewarm.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Jan 31, 2017 at 9:47 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> Now, I assume that this patch sorts the I/O (although I haven't
> checked that) and therefore I expect that the prewarm completes really
> fast.  If that's not the case, then that's bad.  But if it is the
> case, then it's not really hurting you even if the workload changes
> completely.

-- JFYI Yes in the patch we load the sorted
<DatabaseId,TableSpaceId,RelationId,Forknum,BlockNum>.

-- 
Thanks and Regards
Mithun C Y
EnterpriseDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Improvements in psql hooks for variables