[ADMIN] terminating autovacuum process due to administrator command

2012-06-22 Thread Radovan Jablonovsky
, which effectively rendered it unusable for client applications. What could cause this behaviour? Sincerely, -- *Radovan Jablonovsky* DBA **

Re: [ADMIN] terminating autovacuum process due to administrator command

2012-06-25 Thread Radovan Jablonovsky
e 557 schemas each with about 1300 objects (760 tables 520 views). On Mon, Jun 25, 2012 at 2:03 AM, Albe Laurenz wrote: > Radovan Jablonovsky wrote: > > Could you please help with this peculiar problem? > > > > > > In PostgreSQL log occurred this message: > > > &g

Re: [ADMIN] terminating autovacuum process due to administrator command

2012-06-27 Thread Radovan Jablonovsky
+ number of local applications (max app server connections) ) Does it make sense? And if yes why? Sincerely, Radovan Jablonovsky DBA

[ADMIN] PostgreSQL oom_adj postmaster process to -17

2012-07-24 Thread Radovan Jablonovsky
children of postmaster process, will be running with oom_adj set to 0 too? 2) Should the proper Postgresql compilation configuration be: ./configure ... CPPFLAGS="-DLINUX_OOM_ADJ=0" ... 3) Does somebody has experience with this solution for CentOS kernel 2.6.18-308.el5 x86_64? Sincerely,

Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17

2012-08-03 Thread Radovan Jablonovsky
, Aug 1, 2012 at 11:48 AM, Kevin Grittner wrote: > Radovan Jablonovsky wrote: > > > We are running PostgreSQL version 9.1.1 > > You should apply the latest bug fixes by updating to 9.1.4. > > http://www.postgresql.org/support/versioning/ > > > with 32GB of RAM

Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17

2012-08-08 Thread Radovan Jablonovsky
Currently there are maximum 600 connections. On Fri, Aug 3, 2012 at 2:05 PM, Scott Marlowe wrote: > On Fri, Aug 3, 2012 at 12:08 PM, Radovan Jablonovsky > wrote: > > Thanks you for your response. > > > > Database config: > > shared_buffers = 8GB > > tem

[ADMIN] partitioning system tables

2013-10-02 Thread Radovan Jablonovsky
? Sincerely, -- *Radovan Jablonovsky* | SaaS DBA | Phone 1-403-262-6519 (ext. 256) | Fax 1-403-233-8046 * Replicon | Hassle-Free Time & Expense Management Software - 7,300 Customers - 70 Countries www.replicon.com | facebook <http://www.facebook.com/Replicon.inc> | tw