On Wed, Feb 15, 2012 at 12:38 PM, John R Pierce <pierce@xxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
