Re: Vacuum analyse after a long time without one ...

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

 



Nicolas Michel <nicolas.michel@xxxxxxxxx> writes:
> 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.

What is your maintenance_work_mem setting?  It rather looks like it's
more than your system will really allow.

			regards, tom lane

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