From: Matthew T. O'Connor <matthew@zeut.net>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Jeff Boes <jboes@nexcerpt.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: pg_autovacuum crashes when query fails for temp tables
Date: Tue, 20 Apr 2004 23:46:09 -0400
Message-ID: <4085EE81.9080309@zeut.net> (raw)
In-Reply-To: <4085D554.9010802@familyhealth.com.au>
References: <200404201525.i3KFPp809934@candle.pha.pa.us>
<4085D554.9010802@familyhealth.com.au>
Christopher Kings-Lynne wrote:
> Does pg_autovacuum vacuum and analyze system catalog and TOAST tables
> properly?
Properly? I think so, that is to the best of my knowledge which is a
bit limited :-)
Toast Tables: pg_autovacuum doesn't do anything to toast tables
explicitly. I am not aware that they need to be considered, I believe
that if you vacuum table_foo which has an underlying toast table, then
vacuum "does the right thing". Am I wrong? Someone please enlighten me
if I am and I will fix.
System Tables: pg_autovacuum treats non-shared system tables just like
any other table. It monitors the activity and vacuums when it deems it
appropriate. As for shared system tables: In user databases they are
only analyzed by pg_autovacuum, while connected to template1,
pg_autovacuum will treat the shared tables as normal tables and vacuum
when appropriate.
Does all this sound kosher?
Thanks,
Matthew
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: matthew@zeut.net, chriskl@familyhealth.com.au, pgman@candle.pha.pa.us, jboes@nexcerpt.com, pgsql-hackers@postgresql.org
Subject: Re: pg_autovacuum crashes when query fails for temp tables
In-Reply-To: <4085EE81.9080309@zeut.net>
References: <200404201525.i3KFPp809934@candle.pha.pa.us> <4085D554.9010802@familyhealth.com.au> <4085EE81.9080309@zeut.net>
* 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