Re: autovacuum blues - Mailing list pgsql-general

From Matthias.Pitzl@izb.de
Subject Re: autovacuum blues
Date
Msg-id 11EC9A592C31034C88965C87AF18C2A70CFCDA@m0000s61
Whole thread Raw
In response to autovacuum blues  ("Anton Melser" <melser.anton@gmail.com>)
List pgsql-general
Hi Anton!

I'm not sure how this is with 8.1 but on 7.4.14 we have to enable row level
statistics collection for autovacuum:
stats_row_level = true

Greetings,
Matthias

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Anton Melser
> Sent: Thursday, November 09, 2006 1:12 PM
> To: Richard Huxton
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] autovacuum blues

> postgres  1300  0.0  1.1  20180  3048 ?        S    12:03   0:00
> /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
> postgres  1302  0.0  0.2   9968   544 ?        S    12:03   0:00
> postgres: logger process
> postgres  1304  0.0  0.4  20316  1188 ?        S    12:03   0:00
> postgres: writer process
> postgres  1305  0.0  0.6  10968  1544 ?        S    12:03   0:00
> postgres: stats buffer process
> postgres  1306  0.0  0.3  10200   796 ?        S    12:03   0:00
> postgres: stats collector process
> ...
> Any chance you could give me some pointers on activating logging? My
> thoughts were to log
> log_planner_stats = on
> log_min_messages = info
>

pgsql-general by date:

Previous
From: Matthias.Pitzl@izb.de
Date:
Subject: Re: [PL/pgSQL] How should I use FOUND special variable.
Next
From: "Thomas H."
Date:
Subject: Re: planer picks a bad plan (seq-scan instead of index)