Vacuum analyse after a long time without one ...

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

 



I have a problem with a database. The last full vacuum analyse was made
long time ago... So I tried to start launching a vacuum analyse and I
get this error :

$ vacuumdb -az
vacuumdb: vacuuming database "postgres"
VACUUM
vacuumdb: vacuuming database "mexi"
vacuumdb: vacuuming of database "mexi" failed: ERROR:  out of memory
DETAIL:  Failed on request of size 134697600.


Is there a way to recover/vacuum this database? Is there an option in
the postgresql.conf that I can change?

Thanks a lot,
nm.


--
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