pls remember that since the switches didn't run, this all (or mostly) could be related to an unknown process. My bad component appears to have started around 54 seconds into nov 10. The overall job appears to have ended around 01:01:44 which makes me wonder if a lot of the EOFs are related to some sort of cleanup effort between pentaho and postgres. I'm poking around for info on how to run perfmon unattended, how big its footprint would be if monitoring for an extended period of time unattended , and how to look at what the os might have told me that day at that time. I took a peek at available disk space, and while I don't know what postgres might be allowed to take, there is a ton of available space. I closed out about a handful of idle queries on pg admin iii left by programmers. I'll post more soon. 2015-11-10 00:54:03 EST LOG: checkpoints are occurring too frequently (116 seconds apart) 2015-11-10 00:54:03 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:54:24 EST LOG: checkpoints are occurring too frequently (21 seconds apart) 2015-11-10 00:54:24 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:54:46 EST LOG: checkpoints are occurring too frequently (22 seconds apart) 2015-11-10 00:54:46 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:55:11 EST LOG: checkpoints are occurring too frequently (25 seconds apart) 2015-11-10 00:55:11 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:55:36 EST LOG: checkpoints are occurring too frequently (25 seconds apart) 2015-11-10 00:55:36 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:56:07 EST LOG: checkpoints are occurring too frequently (31 seconds apart) 2015-11-10 00:56:07 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:56:38 EST LOG: checkpoints are occurring too frequently (31 seconds apart) 2015-11-10 00:56:38 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:57:15 EST LOG: checkpoints are occurring too frequently (37 seconds apart) 2015-11-10 00:57:15 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:57:53 EST LOG: checkpoints are occurring too frequently (38 seconds apart) 2015-11-10 00:57:53 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:58:35 EST LOG: checkpoints are occurring too frequently (42 seconds apart) 2015-11-10 00:58:35 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:59:12 EST LOG: checkpoints are occurring too frequently (37 seconds apart) 2015-11-10 00:59:12 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 00:59:34 EST LOG: checkpoints are occurring too frequently (22 seconds apart) 2015-11-10 00:59:34 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 01:00:15 EST LOG: checkpoints are occurring too frequently (41 seconds apart) 2015-11-10 01:00:15 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 01:00:46 EST LOG: checkpoints are occurring too frequently (31 seconds apart) 2015-11-10 01:00:46 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 01:01:15 EST LOG: checkpoints are occurring too frequently (29 seconds apart) 2015-11-10 01:01:15 EST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection 2015-11-10 01:01:44 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2015-11-10 01:01:44 EST LOG: unexpected EOF on client connection -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873824.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
