Re: pg_restore - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore
Date
Msg-id 21858.1123872901@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore  ("D Kavan" <bitsandbytes88@hotmail.com>)
Responses Log stdout in PG 8?  (Steve Lane <slane@soliantconsulting.com>)
Re: pg_restore  ("D Kavan" <bitsandbytes88@hotmail.com>)
List pgsql-admin
"D Kavan" <bitsandbytes88@hotmail.com> writes:
> That did the trick.  30 minutes only for a restrore instead of 5 + hours.

Good.

> I did notice that the size is 4 GB instead of 5.6 GB.  Is something else
> going on?

Kinda sounds like you weren't vacuuming often enough in the old
installation, leading to table or index bloat ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Chris Hoover
Date:
Subject: Re: Help with function
Next
From: Tom Lane
Date:
Subject: Re: Help with function