On Wed, May 1, 2013 at 4:56 PM, Jeff Janes wrote:
> That brings up another point to consider. If wal level is minimal, then
> tables which you bulk load in the same transaction as you created them or
> truncated them will not get any WAL records written. (That is the main
> reason the WAL verbos
On Saturday, April 27, 2013, Yang Zhang wrote:
> On Sat, Apr 27, 2013 at 11:55 AM, Jeff Janes
> >
> wrote:
> > On Sat, Apr 27, 2013 at 10:40 AM, Yang Zhang
> > >
> wrote:
> >> My question really boils down to: if we're interested in using COW
> >> snapshotting (a common feature of modern filesys
On Apr 27, 2013, at 10:40 AM, Yang Zhang wrote:
> My question really boils down to: if we're interested in using COW
> snapshotting (a common feature of modern filesystems and hosting
> environments), would we necessarily need to ensure the data and
> pg_xlog are on the same snapshotted volume? I
On Sat, Apr 27, 2013 at 11:55 AM, Jeff Janes wrote:
> On Sat, Apr 27, 2013 at 10:40 AM, Yang Zhang wrote:
>> My question really boils down to: if we're interested in using COW
>> snapshotting (a common feature of modern filesystems and hosting
>> environments), would we necessarily need to ensure
On Sat, Apr 27, 2013 at 10:40 AM, Yang Zhang wrote:
> On Sat, Apr 27, 2013 at 4:25 AM, Jov wrote:
> > Are you sure the EBS snapshot is consistent? if the snapshot is not
> > consistent,enven on the same volume,you will have prolbems with your
> backup.
>
> I think so. EBS gives you "point-in-ti
Yang Zhang writes:
> My question really boils down to: if we're interested in using COW
> snapshotting (a common feature of modern filesystems and hosting
> environments), would we necessarily need to ensure the data and
> pg_xlog are on the same snapshotted volume?
Yeah, I think so. It's possib
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I believe) the usual reasoning for separating pg_xlog onto a separate
volume is for performance. Howe