Re: mirroring table

From: searchelite <searchelite(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: mirroring table
Date: 2008-08-23 07:36:37
Message-ID: 19119465.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig Ringer wrote:
>
> It sounds like what you want is to have a table that contains a full
> history of records, plus another table that contains only the records
> from the first table that were inserted/updated today.
>
> If that is what you mean, there are several ways to do it, with
> different advantages and disadvantages.
>
> You can treat your smaller table as a materialized view, where you use
> triggers to update it and run a batch job (with cron or similar) every
> night to clear it.
>
> Another way is to make it a normal view, possibly with rules in place to
> make it updatable. You could use a partial index on the primary key
> that's restricted to tuples inserted/updated more recently than a given
> date to improve performance of the view.
>
> For that matter, you could even use table partitioning to do it, though
> this would involve a bit of manual (or scripted) maintenance.
>
> Anyway, this is all speculation if I've missed the point of your
> question. If I'm mistaken about what you meant, perhaps you could
> explain in a little more detail?
>
> --
> Craig Ringer
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

Thanks for the reply Craig..this is answered my question...

thanks again

--
View this message in context: http://www.nabble.com/mirroring-table-tp18961792p19119465.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2008-08-23 10:51:58 Re: [Q] DNS(bind) ER model
Previous Message David Fetter 2008-08-23 01:13:58 Re: Ranking?