On Wed, Feb 15, 2012 at 12:38 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> so, your ~ monthly batch run could be something like...
>
> create new partition table
> copy/insert your 1-2 billion rows
> vacuum analyze (NOT full) new table
> vacuum freeze new table
> update master partition table rules
Just FYI, you can "vacuum freeze analyze;" all at once.