Re: 9.4+ partial log-shipping possible?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.4+ partial log-shipping possible?
Date: 2015-03-27 17:12:59
Message-ID: 20150327171259.GA8184@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 26, 2015 at 04:32:00PM +0100, Sven Geggus wrote:
>
> We need to somehow save the state of the osm database to be able to apply
> future changes. This is currently done using a few tables in the target
> database. However these tables are not needed for map rendering and are
> consuming by far the most disk space (still somewhat expensive on SSD)!

This doesn't actually solve your problem, but you could mitigate the
cost by putting those tables on spinning-rust disks using tablespaces
or symlinks or whatever.

Best regards,

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eli Murray 2015-03-27 17:40:11 Building JSON objects
Previous Message Deven Phillips 2015-03-27 16:56:25 json-patch support?