pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Boes <jboes@nexcerpt.com>
To: pgsql-admin@postgresql.org
Subject: pg_autovacuum bug with temp tables?
Date: Tue, 17 Feb 2004 10:26:20 -0500
Message-ID: <4032329C.5010703@nexcerpt.com> (raw)

Recently I installed and started pg_autovacuum against my new Pg 7.4.1 
installation. We use a fairly large number of temporary tables within an 
application (that is, several copies of this application may be running, 
and each creates and drops several temp tables as they cycle through 
their workload). Here's what I think happened, based on the log 
(pg_autovacuum's and the postmaster's):

pg_autovacuum.log:
[2004-02-15 08:10:01 AM] Performing: ANALYZE "pg_temp_13"."tmp_targs"
[2004-02-15 08:10:01 AM] Can not refresh statistics information from the 
database nexcerpt.
[2004-02-15 08:10:01 AM] The error is [ERROR:  relation 
"pg_temp_13.tmp_targs" does not exist

postmaster.log:
2004-02-15 08:10:01 [31563] ERROR:  relation "pg_temp_13.tmp_targs" does 
not exist
2004-02-15 08:10:01 [31563] LOG:  unexpected EOF on client connection


It appears that pg_autovacuum collected the name of a temp table, and 
later tried to analyze it. The table was gone by then, and this caused 
the daemon to exit. As this happened on a Sunday morning, my weekend 
experiment to see how pg_autovacuum would maintain our test database was 
rather spoiled ... 8-(

-- 
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise




Message-ID: <4032329C.5010703@nexcerpt.com>
Permalink:  ../4032329C.5010703@nexcerpt.com/
Also on:    postgresql.org/message-id/4032329C.5010703@nexcerpt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jboes@nexcerpt.com
  Subject: Re: pg_autovacuum bug with temp tables?
  In-Reply-To: <4032329C.5010703@nexcerpt.com>
  References: <4032329C.5010703@nexcerpt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox