Re: a few questions on backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marco Colombo <pgsql(at)esiway(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: a few questions on backup
Date: 2007-05-16 19:04:17
Message-ID: 6059.1179342257@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marco Colombo <pgsql(at)esiway(dot)net> writes:
> Good to know, thanks. I think I'll experiment a bit with
> archive_command. My point was that since I know (or better assume) that
> old segments are going to stay in my pg_xlog for *days* before getting
> recycled,

On what do you base that assumption? Once the system thinks they're not
needed anymore, they'll be recycled immediately.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Greenwood 2007-05-16 19:09:58 Re: to_number behavior change between 8.1 and 8.2
Previous Message Tom Lane 2007-05-16 18:50:32 Re: stats collector spins my disk up every 500ms (8.2.3)