PG Errors when opening tickets

[dvanzuijlekom]

The default for PostgreSQL’s max_connections is usually set at 100 connections. If you’re hitting that, you should see a specific line in your logs. I have written a bit about this in the following post:

Performance problems with 30 employees

If you’re hitting the PostgreSQL max_connections limit, you should see this in your PostgreSQL logs, e.g. something like: FATAL: remaining connection slots are reserved for non-replication superuser connections So inspect your database logs for errors like this. Blindly raising max_connections to an arbitrary high number is a bit of a dumb idea. Here is a pretty good write-up on the subject. I would start looking for I/O bottlenecks, e.g. disk or database. The data you’ve supplied doesn’t me…