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>
index | next in thread | previous in thread | raw e-mail
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 Barwickhome | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAB8KJ=h6MJV2ndETgD1zYwPxWj1rtzUbyPf3swRyQ8vBc=z92g>