Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> LOG: autovacuum: found orphan temp table "pg_temp_2"."foo" in database
> "postgres"
> I remember the discussion when that was put in, but I'm starting to
> think that printing that every time autovacuum wakes up, which is once
> per minute by default, is too noisy.
What else would you do? I can't see adding state to remember when we
printed it last.
> Also, it doesn't give me any hint
> on what I can do to get rid of the message; I had to search the archives
> to find out that I can "DROP SCHEMA pg_temp_2".
We could surely add an errhint() to the message.
regards, tom lane