Re: Question about maintenance_work_mem and shared_buffer

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

 



Rodrigo Barboza wrote:
> I have a doubt.
> I have a 32-bit postrgesql running with 2.5gb of shared_buffer.
> And I have maintenance_work_mem = 1gb and autovacuum_max_workers = 3.
> How maintenance_work_mem is related to shared_buffer?
> If the 3 workers uses 1gb, will the database crash?
> Or their memory usage are separated from each other?

Your doubt is quite in place, as a process on a 32-bit architecture
cannot address more than 4GB of memory.

See http://rhaas.blogspot.jp/2011/05/sharedbuffers-on-32-bit-systems.html

shared_buffers plus the private memory of a backend shouldn't
exceed 3GB.

So I'd go for shared_buffers = 2GB and maintenance_work_mem much
smaller than 1GB.

Yours,
Laurenz Albe


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