Re: database/table snapshot

On 2009-01-30, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> wrote:
> Hey folks,
>
> I wonder, how would you guys approach table snapshots.
> So the thing is, I have table X (I have few more tables, but lets
> simplify that). That table is being replicated to X' on other server.
> Now I need an ability to see changes, say every interval T. So, the
> simplest solution would be to insert all that data to table Xs, with
> additional time column,
> but that obviously will take vast amounts of space. Is there any
> existing algorithm for doing that, or perhaps there's something in
> postgres that would allow me to do it - but I don't know about ?
> thx.

use a trigger to log all updates, inserts, and deletes, to a log table

write a function that returns the contents of the table at a given time.