'Re: [GENERAL] Question regarding autovacuum in 8.1'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Question regarding autovacuum in 8.1
From:       Denis Gasparin <denis () edistar ! com>
Date:       2007-08-30 6:36:59
Message-ID: 46D6658B.9030608 () edistar ! com
[Download RAW message or body]

Alvaro Herrera ha scritto:
>> However i have no idea of what tables the autovacuum daemon is
>> processing because there aren't autovacuum info columns on
>> pg_stat_all_tables (as there are for 8.2.x).
>>     
>
> For that, you need to change log_min_messages to debug2.
>
> Keep track of the PID of autovacuum from the "processing database"
> message and see if you can spot an ERROR message from it.
>
>   
Ok. Thank you.
Another question/idea: why don't put messages about what tables got
vacuumed by the autovacuum daemon as normal log messages (instead of
debug2)?
I think it could be useful because in this way you can also know what
tables are used more often then other...
If i'm not wrong, the old autovacuum process in 7.4 and 8.0 did that...

Denis


[Attachment #3 (text/html)]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Alvaro Herrera ha scritto:<br>
<blockquote cite="mid:20070829155956.GH7911@alvh.no-ip.org" type="cite">
  <blockquote type="cite">
    <pre wrap="">However i have no idea of what tables the autovacuum daemon is
processing because there aren't autovacuum info columns on
pg_stat_all_tables (as there are for 8.2.x).
    </pre>
  </blockquote>
  <pre wrap=""><!---->
For that, you need to change log_min_messages to debug2.

Keep track of the PID of autovacuum from the "processing database"
message and see if you can spot an ERROR message from it.

  </pre>
</blockquote>
Ok. Thank you.<br>
Another question/idea: why don't put messages about what tables got
vacuumed by the autovacuum daemon as normal log messages (instead of
debug2)?<br>
I think it could be useful because in this way you can also know what
tables are used more often then other...<br>
If i'm not wrong, the old autovacuum process in 7.4 and 8.0 did that...<br>
<br>
Denis<br>
<br>
</body>
</html>


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic