pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rob Fielding <rob@dsvr.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: PG 7.2.4 and waiting backends
Date: Wed, 31 Mar 2004 00:45:31 -0500
Message-ID: <29322.1080711931@sss.pgh.pa.us> (raw)
In-Reply-To: <40695D5C.7090101@dsvr.net>
References: <40695D5C.7090101@dsvr.net>

Rob Fielding <rob@dsvr.net> writes:
> The intention is to migrate the DB from 7.2 to a later version. The 
> interim has been to get up to the latest 7.2.4 release inorder to 
> circumvent a vacuumdb corner case which was resulting in a FULL failing. 

Hmm ... why do you feel that you have to do a VACUUM FULL before you
can dump and reload to go to a later version?  AFAICS a vacuum in such a
context is just a waste of cycles.  It's certainly not going to reduce
the size of the dump.

The problems you are describing sound like index bloat to me.  If the
real issue is you haven't got enough disk space to do the dump, I'd
suggest dropping all your indexes, after making notes so you can
recreate them after finishing the upgrade.

			regards, tom lane



view thread (3+ messages)

Message-ID: <29322.1080711931@sss.pgh.pa.us>
Permalink:  ../29322.1080711931@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/29322.1080711931@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, rob@dsvr.net
  Subject: Re: PG 7.2.4 and waiting backends
  In-Reply-To: <29322.1080711931@sss.pgh.pa.us>
  References: <40695D5C.7090101@dsvr.net> <29322.1080711931@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox