Re: [GENERAL] Slow PITR restore

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Jeff Trout <threshar(at)threshar(dot)is-a-geek(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Slow PITR restore
Date: 2007-12-13 13:31:19
Message-ID: 20071213133119.GG6262@alvh.no-ip.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Simon Riggs wrote:

> ISTM its just autovacuum launcher + Hot Standby mixed.

I don't think you need a launcher at all. Just get the postmaster to
start a configurable number of wal-replay processes (currently the
number is hardcoded to 1).

--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
"Someone said that it is at least an order of magnitude more work to do
production software than a prototype. I think he is wrong by at least
an order of magnitude." (Brian Kernighan)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marko Kreen 2007-12-13 13:31:24 Re: accessing multiple databases using dblink
Previous Message Alvaro Herrera 2007-12-13 13:18:04 Re: Slow PITR restore

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2007-12-13 13:55:00 Re: [Fwd: [PATCHES] archiver ps display]
Previous Message Alvaro Herrera 2007-12-13 13:22:21 Re: result of convert_to is bytea