>> So, if any data is written during taking snapshot, we can't assurance data >> correctness *strictly* . That sounds nothing like what I've heard called a "snapshot" before. Some "filesystems" which aren't really filesystems but are also storage layer drivers like Veritas (and ZFS?) allow you to take a snapshot which they guarantee is atomic. You can do them while you have concurrent i/o and be sure to get a single consistent view of the filesystem. If you're just copying blocks from a device without any atomic snapshot guarantee then you're going to get garbage. Even in Postgres wasn't writing anything the OS might still choose to flush blocks during that time, possibly not even Postgres data blocks but filesystem meta-information blocks. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
