Date: Wed, 3 Apr 2013 07:44:56 +0900 From: Ian Lawrence Barwick <barwick@gmail.com> To: David.I.Noel@gmail.com Cc: freebsd-database@freebsd.org, PGSQL Mailing List <pgsql-general@postgresql.org> Subject: Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100% Message-ID: <CAB8KJ=h6MJV2ndETgD1zYwPxWj1rtzUbyPf3swRyQ8vBc=z92g@mail.gmail.com> In-Reply-To: <CAHAXwYDg7ijxaG8K8vHMQci552txe94U4KKKJ4cZbUHT5UGXcQ@mail.gmail.com> References: <CAHAXwYDg7ijxaG8K8vHMQci552txe94U4KKKJ4cZbUHT5UGXcQ@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
2013/4/3 David Noel <david.i.noel@gmail.com>: > I'm running into a strange issue whereby my postgres processes are > slowly creeping to 100% CPU utilization. I'm running > postgresql-server-9.2.3, FreeBSD 8.3-RELEASE-p6, and using the > postgresql-9.2-1002.jdbc4 driver. (...) > postgresql.conf, all standard/default except for: > max_connections = 256 It's very likely the default settings are woefully inadequate for your server; some basic tuning (especially the value of shared_buffers and other memory-related parameters) should help. > Any thoughts? What other information can I provide? Sample EXPLAIN/EXPLAIN ANALYZE output from the query in question, and if possible relevant table definitions etc. would certainly be useful. Regards Ian Barwick
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAB8KJ=h6MJV2ndETgD1zYwPxWj1rtzUbyPf3swRyQ8vBc=z92g>