searchelite wrote: > Hi all..how can i mirroring table in postgresql? > Let say i have a transaction table updated everyday, i want to mirror that > table so that the other table only store the latest updated day records.. > I hope you can understand my question.. 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
