Re: Seeking datacenter PITR backup suggestions

From: Decibel! <decibel(at)decibel(dot)org>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: "Joey K(dot)" <pguser(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Seeking datacenter PITR backup suggestions
Date: 2007-08-29 00:03:49
Message-ID: 20070829000349.GN1386@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 28, 2007 at 11:05:52AM -0700, Steve Crawford wrote:
> In your scenario, what about using "cp -l" (or "ln") instead? Since the
> hard-link it is only creating a new pointer, it will be very fast and
> save a bunch of disk IO on your server and it doesn't appear that the
> tempdir is for much other than organizing purposes anyway.

Note that that will only work if you're creating the link on the same
filesystem, and having /tmp and your data in the same filesystem isn't
such a hot idea.
--
Decibel!, aka Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Decibel! 2007-08-29 00:05:30 Re: Seeking datacenter PITR backup suggestions
Previous Message Tom Lane 2007-08-28 23:41:27 Re: Out of Memory - 8.2.4