Dear All,
We encountered this for the 3rd time after completing a PITR.
The database starts up as usual and we could carry out the read and write transactions. After a while the following errors start appearing in the log. So we tried running vacuumdb with options All,Freeze,Analyze to see if that can clear the logs. That is why we get the entries "checkpoints are occurring too frequently (11 seconds apart)" and so on. However during and after the vacuumdb is completed the "orphan temp table" entry keeps on printing in the log. Anyone has any idea why this is happening?
2011-04-19 12:12:31 MYT LOG: connection
received: host=[local]
2011-04-19 12:12:31 MYT LOG: connection
authorized: user=postgres database=np
2011-04-19 12:12:46 MYT LOG:
checkpoints are occurring too frequently (11 seconds apart)
2011-04-19
12:12:46 MYT HINT: Consider increasing the configuration parameter
"checkpoint_segments".
2011-04-19 12:12:48 MYT LOG: checkpoints are
occurring too frequently (2 seconds apart)
2011-04-19 12:12:48 MYT
HINT: Consider increasing the configuration parameter
"checkpoint_segments".
2011-04-19 12:12:49 MYT LOG: checkpoints are
occurring too frequently (1 second apart)
2011-04-19 12:12:49 MYT HINT:
Consider increasing the configuration parameter
"checkpoint_segments".
2011-04-19 12:12:59 MYT LOG: autovacuum: found
orphan temp table "pg_temp_108"."session_id" in database "np"
2011-04-19
12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_19"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_35"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_18"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_21"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_6"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_42"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_12"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_30"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_17"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_8"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_44"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_46"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_25"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_5"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_22"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_120"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_36"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_47"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_13"."session_id" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_14"."session_id" in database
"np"
2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table
"pg_temp_15"."tmp_swsv" in database "np"
2011-04-19 12:12:59 MYT LOG:
autovacuum: found orphan temp table "pg_temp_69"."session_id" in database
"np"
2011-04-19 12:13:05 MYT LOG: checkpoints are occurring too
frequently (16 seconds apart)
2011-04-19 12:13:05 MYT HINT: Consider
increasing the configuration parameter
"checkpoint_segments".
