Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: [HACKERS] Proposal : For Auto-Prewarm.
Date
Msg-id 726e45cb-58c2-6fc9-d0ed-7175006fa276@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] Proposal : For Auto-Prewarm.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] Proposal : For Auto-Prewarm.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On 2/26/17 11:46, Robert Haas wrote:
> I don't see
> a solution other than launching a separate worker for each database,
> which seems like it could be extremely expensive if there are many
> databases.

You don't have to start all these workers at once.  Starting one and not
starting the next one until the first one is finished should be fine.
It will have the same serial behavior that the patch is proposing anyway.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] WIP: Covering + unique indexes.
Next
From: Surafel Temesgen
Date:
Subject: [HACKERS] Disallowing multiple queries per PQexec()