Re: Unloading a table consistently

From: Reece Hart <reece(at)harts(dot)net>
To: Christophe <xof(at)thebuild(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unloading a table consistently
Date: 2008-05-13 22:22:24
Message-ID: 1210717344.29078.26.camel@snafu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 2008-05-03 at 09:11 -0700, Christophe wrote:

> I will have a log table which, once a day or so, is copied to a file
> (for movement to a data warehouse), and the log table emptied.

...

> Is there a better way to handle this kind of thing that I'm
> missing?

Anyone care to comment about whether a table partition might be better
here? Could an insert rule on a table partition automatically create the
inherited table, if needed, and insert there?

Thanks,
Reece

--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-05-13 22:43:25 Re: Alias in the HAVING clause
Previous Message Scott Marlowe 2008-05-13 22:22:03 Re: Alias in the HAVING clause