Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



--- On Mon, 4/4/11, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> > So it appears now that if I restore the database using
> pg_restore, I end up with bloated indexes, which are fixed
> with a vacuum full.
> 
> > The dump is a data only dump with the -Fc flag,
> 
> Data only dump?  Then what is the state of the
> database you're restoring
> it into?
> 

It's a newly created database from a schema only dump.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux