Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100%

Ian Lawrence Barwick <[email protected]> Wed, 3 Apr 2013 07:44:56 +0900

Newsgroups	gmane.os.freebsd.devel.database,gmane.comp.db.postgresql.general
Message-ID	<CAB8KJ=h6MJV2ndETgD1zYwPxWj1rtzUbyPf3swRyQ8vBc=z92g@mail.gmail.com>

2013/4/3 David Noel <[email protected]>:
> 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
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[email protected]"