Re: Suspending postgresql during heavy load

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

 



On Tue, Oct 7, 2014 at 9:07 AM, The Doctor <doctor@xxxxxxxxxxxxxxxxx> wrote:
> Question is their a way to suspend PostGres during a heavy average load
> session?
>
> I would like to suspend Postgresql transaction on a load average higher
> then a load average of 5.

So you just want to stop the db under heavy load? I'm not sure what
you're asking here. PostgreSQL is designed around a transactional
model, it can't just be shut off at your convenience.

OTOH you might want to look at how you're using it and what kind of
hardware you're using and if you need to upgrade it.


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